{"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":"Gapless sequences","slug":"gapless-sequences","published_at":"2025-10-31T14:00:00+00:00","page_url":"https://stenobird.com/podcast/postgres-fm-5565051/gapless-sequences","show_page_url":"https://stenobird.com/podcast/postgres-fm-5565051","url":"https://share.transistor.fm/s/51ef75f8","audio_url":"https://media.transistor.fm/51ef75f8/d50337bd.mp3","summary":"Nik and Michael discuss the concept of gapless sequences — when you might want one, why sequences in Postgres can have gaps, and an idea or two if you do want them. And one quick clarification: changing the CACHE option in CREATE SEQUENCE can lead to even more gaps, the docs mention it explicitly. Here are some links to things they mentioned: CREATE SEQUENCE https://www.postgresql.org/docs/current/sql-createsequence.html Sequence Manipulation Functions https://www.postgresql.org/docs/current/functions-sequence.html One, Two, Skip a Few (post by Pete Hamilton from Incident io) https://incident.io/blog/one-two-skip-a-few Postgres sequences can commit out-of-order (blog post by Anthony Accomazzo / Sequin) https://blog.sequinstream.com/postgres-sequences-can-commit-out-of-order Logical Replication of sequences (hackers thread) https://www.postgresql.org/message-id/flat/CAA4eK1LC%2BKJiAkSrpE_NwvNdidw9F2os7GERUeSxSKv71gXysQ%40mail.gmail.com Synchronization of sequences to subscriber (patch entry in commitfest) https://commitfest.postgresql.org/patch/5111/ Get or Create (episode with Haki Benita) https://postgres.fm/episodes/get-or-create German tank problem https://en.wikipedia.org/wiki/German_tank_problem ~~~ 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 credit to: Jessie Draws for the elephant artwork","meta_description":"Nik and Michael discuss the concept of gapless sequences — when you might want one, why sequences in Postgres can have gaps, and an idea or two if you do…","key_points":[],"chapters":[],"topics":[],"duration_seconds":2389,"processing_state":"not_requested","actions":[{"name":"request_transcript","method":"POST","url":"https://stenobird.com/v1/public/podcasts/postgres-fm-5565051/episodes/gapless-sequences/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/gapless-sequences.md","description":"Read the agent-friendly Markdown representation of this episode resource."}]}}