Don't Do This! (PostgreSQL Mistakes and How to Avoid Them)

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)

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!

[rosendo]

singing during the presentation....wow...!!!

[professortrog]

Second item: if you don’t need a time-part in a date-time, DON’T use it. Just use the date part.