The PostgreSQL Twin Bill: The 7 Deadly PostgreSQL Mistakes & Review of What's New in PostgreSQL 14
summary
Lists ten common production failures with concrete fixes and PG14 counters: wrong middleware choice (pgbouncer vs HAProxy vs pgpool), pg_repack issues and autovacuum tuning errors, connection bloat from no pooling, over/under indexing, unsafe extensions, untested backups and RPO/RTO tradeoffs, poor schema types (UUID vs integer), and overengineering. PG14 adds ~200 updates including pipeline mode, parallel FDW queries, improved vacuum/index stats, pg_stat_wal and replication slot views, and recommends retain backups for seven days.
AI-written summary · about
chapters (21)
- 0:00Introduction
- 1:25Who are we
- 2:31Where we see the most issues
- 3:24Tool selection
- 5:25Security
- 6:50Vacuum
- 7:57Poor Connection Management
- 9:09Default Settings
- 9:57Wall Settings
- 10:30Indexing
- 11:49Extensions
- 13:03Backups
- 18:16Bad Design
- 24:56PostgreSQL 14 Upgrade
- 25:40Performance Improvements
- 26:31Data Types and Functions
- 27:16Vacuum Enhancements
- 28:52Standby Enhancements
- 29:32Security Enhancements
- 30:27Additional Updates
- 32:15Potential Problems
related talks
01h 00mThe 10 Deadly PostgreSQL Sins
47mPostgreSQL worst practices
36mPostgreSQL worst practices
48mPostgreSQL Replication: 20 Pitfalls and Solutions
55mA look at the Elephants Trunk: PostgreSQL 14
46mThe Top 10 Mistakes When Migrating Oracle Databases to PostgreSQL
51mHow Postgres is misused and abused in the wild
42mPostgres: stories that will scare you