Understanding Multi-Version Concurrency Control in PostgreSQL
Presented by:

Haripriya Naidu
No video of the event yet, sorry!
Have you ever wondered how PostgreSQL handles concurrent reads and writes without blocking operations? Or how it minimizes deadlocks and ensures data consistency? In this session, we’ll explore Multi-Version Concurrency Control (MVCC) in PostgreSQL.
I'll explain how MVCC manages reads when there are concurrent writes to a table and how it cleans up after transactions commit. I'll also discuss the potential downsides of MVCC and things you need to be cautious about.
By the end of the session, you’ll have a deeper understanding of how PostgreSQL uses MVCC to improve performance and concurrency while maintaining data consistency.
- Date:
- 2025 March 21 13:30 EDT
- Duration:
- 20 min
- Room:
- Gold Coast 3&4
- Conference:
- Postgres Conference 2025
- Language:
- Track:
- Essentials
- Difficulty:
- Easy