Schedule - PGConf.DE 2023
Don't Do This
Date: 2023-06-27
Time: 09:10–09:55
Room: Saal A1
Level: Intermediate
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)
Slides
The following slides have been made available for this session: