The Long Transaction — When Size Matters
summary
Examines why long-running transactions degrade PostgreSQL performance by analyzing one real process example. Covers transaction isolation levels, row visibility rules, hint bits and the "mini-vacuum" mechanism to explain how seemingly unrelated activities interact and slow the database.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 6:30Performance issues
- 12:12MVCC in PostgreSQL
- 20:31Index and pointer problems
- 26:11Long transactions impact
- 31:51Solution and optimization
- 37:09Diagnostics and monitoring
- 41:29Q&A
related talks
31m5 Wrong Hypotheses about PostgreSQL Multi-Transaction Locks
16mTransactionality Explained
17mTransactionalism Explained
41mConcurrency, Scalability and Transactions -- Myths and Surprises
41mTransactions: myths, surprises and opportunities
52mBulk data processing and PostgreSQL thingy
48mUnderstanding and Reducing Application Contention
33mPostgres Storytelling: Support in the Darkest Hour