A look at the Elephants Trunk: PostgreSQL 14
summary
PostgreSQL 14 ships (released 2021-09-30) with concrete changes: scram-sha-256 default (breaks very old clients), SSL compression removal, and idle_session_timeout plus client‑connection liveness checks to kill stale queries. Observability gains include pg_stat_statements_info, pg_stat_wal and pg_backend_memory_contexts; logical replication can stream large transactions. Performance adds snapshot scalability improvements for many CPUs, runtime partition pruning for updates/deletes, BRIN multi min/max, lz4 TOAST, pipeline mode in libpq, and vacuum fail‑safe at ~1.6 billion xids.
AI-written summary · about
chapters (16)
- 0:00Start
- 4:40New features
- 5:14SCRAM
- 6:56SSL compression
- 8:30Version 2 wire
- 9:20Predefined roles
- 13:28Idle connections
- 16:27Statistics
- 23:51Generic subscripting
- 26:29Stored procedures
- 40:09DETACH
- 40:56BRIN indexes
- 43:20Window functions
- 44:08Parallelism
- 47:35libpq pipeline mode
- 48:05VACUUM
related talks
52mA look at the Elephants Trunk - PostgreSQL 15
50mA look at the elephant's trunk - PostgreSQL 10
30mA Look at the Elephant's Trunk PostgreSQL 13
35mThe PostgreSQL Twin Bill: The 7 Deadly PostgreSQL Mistakes & Review of What's New in PostgreSQL 14
46mPostgreSQL 16 and beyond
48mWhat's New in PostgreSQL 9.4
43mPostgreSQL 17 and beyond
54mBreakout Session