Don't Do This

FOSDEM 2023

Based on the legendary "Don't Do This" PostgreSQL wiki page, this talk will explore some of the common pitfalls and misconceptions that Postgres users can face - and show possible ways to undo them or workarounds.

Some of the topics to be covered:

Correct types for data storage
(Sub-)Partitioning
- And how to get it wrong
Bad SQL habits
Table inheritance
- And how to undo it
Security issues
- Unsafe configurations and usage
Connections
- Number of, and properly handling

Speakers: Jimmy Angelakos