Brussels / 4 & 5 February 2023


Don't Do This

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


Photo of Jimmy Angelakos Jimmy Angelakos