A look at the Elephants Trunk - PostgreSQL 15
summary
PostgreSQL 15 is at release-candidate stage with five commit fests behind it and a release expected within weeks; key changes include dropping PL/Python2, removing default CREATE for public schema (may break apps), a new PG_CHECKPOINT role, grants on GUCs, shared_memory_size/hugepages reporting, pg_stat_statements I/O timing, JSON logging, ICU locales as provider, and server-side compression for pg_basebackup. SQL adds MERGE is not atomic (set-oriented merge vs INSERT ... ON CONFLICT), partial FK SET NULL, row and column filtering for logical replication, lz4/zstd compression, and recovery prefetch via fadvise.
AI-written summary · about
chapters (12)
- 0:00Introduction and schedule
- 2:58PostgreSQL 15 development
- 6:09Breaking changes in PostgreSQL 15
- 12:07DBA and admin improvements
- 17:29Monitoring and logging updates
- 21:11Security and locale features
- 23:13SQL and developer enhancements
- 28:08MERGE command introduction
- 33:45Backup and replication updates
- 40:34Performance optimizations
- 44:10Compression features
- 49:44Q&A and closing remarks
related talks
55mA look at the Elephants Trunk: PostgreSQL 14
50mA look at the elephant's trunk - PostgreSQL 10
30mA Look at the Elephant's Trunk PostgreSQL 13
54mBreakout Session
51mExploring new enhancements and improvements Fujitsu has delivered to
28mPostgreSQL 9.4 and Beyond
46mPostgreSQL 16 and beyond
48mWhat's New in PostgreSQL 9.4