{"podcast":{"title":"Postgres FM","slug":"postgres-fm-5565051","podcast_index_feed_id":5565051,"rss_url":"https://feeds.transistor.fm/postgres-fm","website_url":null,"image_url":"https://img.transistorcdn.com/F-bi_aUNst-Ey8rEcRiURSNfKPb3cxsaDOvekkdqtR8/rs:fill:0:0:1/w:1400/h:1400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.jpg","author":"Nikolay Samokhvalov and Michael Christofides","episode_count":184,"summary":"A weekly podcast about all things PostgreSQL","last_synced_at":"2026-07-25T00:17:17.794402+00:00","page_url":"https://stenobird.com/podcast/postgres-fm-5565051"},"episode":{"title":"Postgres 18","slug":"postgres-18","published_at":"2025-09-26T13:00:00+00:00","page_url":"https://stenobird.com/podcast/postgres-fm-5565051/postgres-18","show_page_url":"https://stenobird.com/podcast/postgres-fm-5565051","url":"https://share.transistor.fm/s/affec5aa","audio_url":"https://media.transistor.fm/affec5aa/ef7e0d17.mp3","summary":"Nik and Michael discuss the newly released Postgres 18 — the bigger things it includes, some of their personal highlights, and some thoughts towards the future. Here are some links to things they mentioned: Postgres 18 announcement https://www.postgresql.org/about/news/postgresql-18-released-3142 Postgres 18 release notes https://www.postgresql.org/docs/18/release-18.html Skip scan episode with Peter Geoghegan https://postgres.fm/episodes/skip-scan Easier Postgres fine-tuning with online_advisor https://neon.com/blog/easier-postgres-fine-tuning-with-online_advisor pganalyze Index Advisor https://pganalyze.com/index-advisor BUFFERS by default https://postgres.fm/episodes/buffers-by-default Buffers II (the sequel) https://postgres.fm/episodes/buffers-ii-the-sequel Return of the BUFFERS https://postgres.fm/episodes/return-of-the-buffers UUID https://postgres.fm/episodes/uuid Partitioning by ULID https://postgres.fm/episodes/partitioning-by-ulid uuidv7 and uuid_extract_timestamp functions https://www.postgresql.org/docs/current/functions-uuid.html Add --no-policies option to pg_dump, pg_dumpall, and pg_restore https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=cd3c45125 Add ONLY support for VACUUM and ANALYZE https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=62ddf7ee9 Make \"vacuumdb --analyze-only\" process partitioned tables (committed recently for Postgres 19) https://commitfest.postgresql.org/patch/5871/ NOT VALID constraints https://postgres.fm/episodes/not-valid-constraints The year of the Lock Manager’s Revenge (post by Jeremy Schneider) https://ardentperf.com/2024/03/03/postgres-indexes-partitioning-and-lwlocklockmanager-scalability Increase the number of fast-path lock slots https://git.postgresql.org/gitweb/?p=postgresql.git;a=commi…","meta_description":"Nik and Michael discuss the newly released Postgres 18 — the bigger things it includes, some of their personal highlights, and some thoughts towards the f…","key_points":[],"chapters":[],"topics":[],"duration_seconds":3343,"processing_state":"not_requested","actions":[{"name":"request_transcript","method":"POST","url":"https://stenobird.com/v1/public/podcasts/postgres-fm-5565051/episodes/postgres-18/transcription-requests","description":"Idempotently request low-priority transcript generation for this episode."},{"name":"read_markdown","method":"GET","url":"https://stenobird.com/podcast/postgres-fm-5565051/postgres-18.md","description":"Read the agent-friendly Markdown representation of this episode resource."}]}}