Episode 116
Postgres 17
Postgres FM · Nikolay Samokhvalov and Michael Christofides
September 27, 202442m 3s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Nikolay and Michael discuss the fresh new Postgres 17 release! They cover several performance improvements, favourite new features, and some considerations for upgrading.
Here are some links to things they mentioned:
- Postgres 17 release notes https://www.postgresql.org/docs/17/release-17.html
- transaction_timeout episode https://postgres.fm/episodes/transaction_timeout
- VACUUM improvements discussed towards end of episode with Melanie Plageman https://postgres.fm/episodes/getting-started-with-benchmarking
- B-tree improvements discussed in episdode with Peter Geoghegan https://postgres.fm/episodes/skip-scan
- As Rails developers, why we are excited about PostgreSQL 17 (blog post by Benoit Tigeot) https://benoittgt.github.io/blog/postgres_17_rails/
- Real World Performance Gains With Postgres 17 B-tree Bulk Scans (blog post by Brandur Leach) https://www.crunchydata.com/blog/real-world-performance-gains-with-postgres-17-btree-bulk-scans
- MERGE RETURNING came up towards end of episode with Haki Benita https://postgres.fm/episodes/get-or-create
- uuid_extract_timestamp and uuid_extract_version functions https://www.postgresql.org/docs/current/functions-uuid.html
- Episode on UUID https://postgres.fm/episodes/uuid
- Partitioning by ULID https://postgres.fm/episodes/partitioning-by-ulid
- Why Upgrade? (site by depesz) https://why-upgrade.depesz.com
- Why we spent the last month eliminating PostgreSQL subtransactions (GitLab blog post) https://about.gitlab.com/blog/2021/09/29/why-we-spent-the-last-month-eliminating-postgresql-subtransactions
- Synchronization of sequences to subscriber (patch that needs review!) https://commitfest.postgresql.org/49/5111
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is produced by:
- Michael Christofides, founder of pgMustard
- Nikolay Samokhvalov, founder of Postgres.ai
With special thanks to:
- Jessie Draws for the elephant artwork
Topics
PostgresPostgreSQLDatabasesSQLtechnology