Postgres 17 | Postgres.FM 116 | #PostgreSQL #Postgres podcast

[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!] 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: * Query Planning (docs) https://www.postgresql.org/docs/current/runtime-config-query.html * Are there limits to partition counts? (Blog post by depesz) https://www.depesz.com/2021/01/17/are-there-limits-to-partition-counts * Nikolay's recent experiment https://postgres.ai/chats/01920004-a982-7896-b8cb-dfd2406359b0 * PgBouncer now supports prepared statements https://github.com/pgbouncer/pgbouncer/releases/tag/pgbouncer_1_21_0 * “The year of the lock manager’s revenge” (from blog post by Jeremy Schneider) https://ardentperf.com/2024/03/03/postgres-indexes-partitioning-and-lwlocklockmanager-scalability * pg_stat_statements.track_planning https://www.postgresql.org/docs/current/pgstatstatements.html#id-1.11.7.42.9.2.4.1.3 * pg_hint_plan https://github.com/ossc-db/pg_hint_plan ~~~ What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm https://twitter.com/PostgresFM, @samokhvalov https://twitter.com/samokhvalov and @michristofides https://twitter.com/michristofides ~~~ Postgres FM is produced by: - Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/ - Michael Christofides, founder of pgMustard https://pgmustard.com/ ~~~ This is the video version. Check out https://postgres.fm for the audio version, to see the transcript, guest profiles, and more.