{"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":"Long-running transactions","slug":"long-running-transactions","published_at":"2026-03-27T14:00:00+00:00","page_url":"https://stenobird.com/podcast/postgres-fm-5565051/long-running-transactions","show_page_url":"https://stenobird.com/podcast/postgres-fm-5565051","url":"https://share.transistor.fm/s/5f6f39cb","audio_url":"https://media.transistor.fm/5f6f39cb/aee9f55d.mp3","summary":"Nik and Michael discuss long-running transactions, including when they're harmless, when they cause issues, and how to mitigate those issues. Here are some links to things they mentioned: transaction_timeout https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-TRANSACTION-TIMEOUT Our episode on transaction_timeout https://postgres.fm/episodes/transaction_timeout Our episode on slow queries (which was also our first ever episode!) https://postgres.fm/episodes/slow-queries-and-slow-transactions Our episode on locks https://postgres.fm/episodes/locks lock_timeout https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-LOCK-TIMEOUT Transaction Isolation levels https://www.postgresql.org/docs/current/transaction-iso.html pg_current_xact_id_if_assigned() https://pgpedia.info/p/pg_current_xact_id_if_assigned.html Monitor xmin horizon to prevent XID/MultiXID wraparound and high bloat (how-to guide by Nik) https://postgres.ai/docs/postgres-howtos/performance-optimization/monitoring/how-to-monitor-xmin-horizon idle_replication_slot_timeout https://www.postgresql.org/docs/current/runtime-config-replication.html#GUC-IDLE-REPLICATION-SLOT-TIMEOUT PREPARE TRANSACTION https://www.postgresql.org/docs/current/sql-prepare-transaction.html log_autovacuum_min_duration https://www.postgresql.org/docs/devel/runtime-config-logging.html#GUC-LOG-AUTOVACUUM-MIN-DURATION PostgreSQL Subtransactions Considered Harmful (blog post by Nikolay) https://postgres.ai/blog/20210831-postgresql-subtransactions-considered-harmful statement_timeout https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-STATEMENT-TIMEOUT idle_in_transaction_session_timeout https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-IDLE-IN-TRANSACTION-SESSION-TIMEOUT…","meta_description":"Nik and Michael discuss long-running transactions, including when they're harmless, when they cause issues, and how to mitigate those issues. Here are som…","key_points":[],"chapters":[],"topics":[],"duration_seconds":2895,"processing_state":"not_requested","actions":[{"name":"request_transcript","method":"POST","url":"https://stenobird.com/v1/public/podcasts/postgres-fm-5565051/episodes/long-running-transactions/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/long-running-transactions.md","description":"Read the agent-friendly Markdown representation of this episode resource."}]}}