Back to all episodes
Episode 19Data & InfrastructureFREE
PostgreSQL MVCC & WAL
4:24 · Alex & Sam
PostgreSQL#postgresql#mvcc#wal#transactions#acid
Show Notes
Postgres handles thousands of concurrent transactions without locking your table. Sam and Alex explain Multi-Version Concurrency Control, the Write-Ahead Log, and VACUUM.
Key Takeaways
- Sam and Alex explain Multi-Version Concurrency Control, the Write-Ahead Log, and VACUUM.
- Core concepts covered: Postgresql, Mvcc, Wal, and 2 more.
- Key trade-offs and design decisions you can apply to your own system design interviews.
Read the full article
PostgreSQL MVCC & Write-Ahead Log — deep dive with diagrams, tradeoffs & interview questions
Architecture Diagram