Don't make these mistakes with #PostgreSQL! [Don't Do This @ #FOSDEM 2023]
Channel: Jimmy Angelakos
Date: 2023-02-09

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

Some of the things discussed:
  - Bad SQL habits
  - Correct types for data storage
  - (Sub-)Partitioning (and how to get it wrong)    
  - Table inheritance (and how to undo it)
  - Connections (number of, and properly handling)
  - Security issues (unsafe configurations and usage)

Talk at #FOSDEM 2023. Slides: https://vyruss.org/computing/slides/fosdem2023_dont_do_this.pdf

Many thanks to Boriss Mejías (tchorix) for his awesome hosting, and Karen Jex (karenhjex) for immediately jumping in to help when my laptop battery hilariously died near the end!