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: vyruss.org/computing/slides/f...
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!