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