Date: 2017-10-25
Time: 09:45–10:45
Room: Baltic I
Level: Beginner
36,321 tables, one row each, one database. A stored procedure with 1,752 parameters. A DBA convinced that storing everything in the entire database typed as BYTEA will definitely improve performance. All of these are true stories, and the sad fact is that many PostgreSQL professionals can relate to them -- even if they won't admit it in public.
In this talk, I will discuss some of my favorite database anti-examples from The Daily WTF (including a particularly egregious one concocted by yours truly), and discuss how they came to be and where they came from. Most importantly, I'll cover how to avoid unintentionally creating your own database WTFs.
The following slides have been made available for this session: