A look at the elephant's trunk - PostgreSQL 10
summary
Postgres 10 removes the dotted versioning and renames xlog paths/functions to WAL (so update scripts), defaults wal_level to replica and enables streaming and temporary replication slots for safer pg_basebackup. It adds scram authentication, logical replication with publications/subscriptions (table-level, no schema/sequence replication yet), transition tables for statement-level triggers, standard identity columns, file_fdw program support, ICU collations, JSONB-aware full‑text indexing, improved parallel query and index scans, hash index fixes, partitioning basics, and multicolumn statistics via CREATE STATISTICS.
AI-written summary · about
chapters (39)
- 0:00Introduction
- 1:10Welcome
- 2:02No dot
- 2:30No Postgres 10
- 3:13Minor versions
- 4:42How we work
- 6:40New features
- 7:37Postgres protocol
- 9:07PostgreSQL log changes
- 11:57MultiX wraparound issue
- 12:43DBA vs Developer
- 13:42SCRAM Authentication
- 16:08Multiple host names
- 18:30Monitoring
- 19:00PD Start Activity
- 21:10Wait Events
- 22:18Monitoring Roles
- 24:35SQL Exposed Features
- 24:47Transition Tables
- 26:34Standard identity columns
- 28:16File foreign data wrapper
- 29:35XML
- 32:37ICU
- 34:38Swedish collation
- 35:55Backup and replication
- 37:05Temporary replication slots
- 38:33Enable while streaming
- 39:04synchronous replication
- 39:37logical replication
- 40:40schema replication
- 42:27partitioning
- 43:48range partitioning
- 45:28parallelism
- 45:44parallel workers
- 46:09index scans
- 46:26parallelization
- 46:47multicolumn statistics
- 48:23need your help
- 49:50conclusion
related talks
55mA look at the Elephants Trunk: PostgreSQL 14
30mA Look at the Elephant's Trunk PostgreSQL 13
52mA look at the Elephants Trunk - PostgreSQL 15
48mWhat's New in PostgreSQL 9.4
31mPast, Present, and Future: Logical Decoding and Replication in PostgreSQL
46mPostgreSQL 16 and beyond
43mPostgreSQL 17 and beyond
56mLogical Replication of DDLs