About this episode

Nik and Michael discuss long-running transactions, their implications, and mitigation strategies.

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…

More episodes of Postgres FM

• pg_wait_tracer · April 24, 2026 · 44 min
• Schema design checklist · April 17, 2026 · 45 min
• What’s Missing in Postgres? · April 3, 2026 · 44 min
• PostGIS · March 13, 2026 · 53 min
• Plan flips · March 6, 2026 · 43 min
• pg_ash · February 20, 2026 · 32 min

Explore listener stats, chart rankings, contacts and more on the Postgres FM podcast page.