Postgres 17 Commit-orama | Scaling Postgres 312

In this episode of Scaling Postgres, we cover potential features in Postgres 17 such as explain serialize, verbose copy, pg_buffer_cache_evict, as well as many others.

Content Discussed

• Waiting for PostgreSQL 17 – Invent SERIALIZE option for EXPLAIN.
• Waiting for PostgreSQL 17 – Add new COPY option LOG_VERBOSITY.
• PostgreSQL 17: pg_buffercache_evict()
• Waiting for Postgres 17: Benchmarking with pg_buffercache_evict
• PostgreSQL 17 features I am most waiting for
• A look at the Elephants Trunk PostgreSQL 17
• Waiting for PostgreSQL 17 – Add support for MERGE … WHEN NOT MATCHED BY SOURCE.
• PostgreSQL 17 commitfest conclusion
• Logical replication common issues
• GQL:2024 is out
• We are moving to General Availability
• Supabase Blog
• Neon: A New Approach to Database Development
• Neon Blog
• Ten years of improvements in PostgreSQL's optimizer
• Mini Summit Three
• Use Cases for Merging and Splitting Partitions With Minimal Locking in PostgreSQL 17
• CloudNativePG Recipe 7: Postgres Vertical Scaling with Storage in Kubernetes - part 2
• Postgres Roles and Privileges
• Building PostgreSQL Extensions: Dropping Extensions and Cleanup
• Improved query cancellation in PostgreSQL 17 and Psycopg 3.2
• Rebuilding Tables online using pg_repack in PostgreSQL
• PG Phriday: Under Observation
• Waiting for …: SQL/JSON is coming back. Hopefully.
• 13 Tips to Improve PostgreSQL Insert Performance
• Hacking Postgres Podcast - Season 2, Ep. 1 - Andrew Atkinson
• PL/pgSQL Conversion Gotchas: Cursors and Last Fetch.
• pgenv: run once scripts
• Operationalizing Vector Databases on Postgres
• PGconf.de 2024 in Munich
• Mastering Query Rewriting for Faster PostgreSQL Performance
• How Timescale Replication Works: Enabling HA in PostgreSQL

YouTube Video

Podcast Audio