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/com...
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!
Негізгі бет Don't make these mistakes with
Пікірлер: 3