Handling Contention with PostgreSQL

Diana Hsieh
Oct 23, 2017 · 2 min read

Understanding how concurrency is achieved under the hood is pretty important for anyone using databases since it impacts things like isolation guarantees and performance. I had originally wanted to share a comparison of how CockroachDB and PostgreSQL use MVCC differently to handle concurrency. However, the CockroachDB implementation had too many additional bells and whistles, and it would have made this post too long. So for now, here’s a quick overview of PostgreSQL’s MVCC model. It’s a complicated topic, so let me know if you see anything I should fix on Twitter @Dianasaur323!

Learning with Diagrams

Distilling infrastructure software into quick and understandable diagrams

Diana Hsieh

Written by

Product @ Timescale. Find me @dianasaur323

Learning with Diagrams

Distilling infrastructure software into quick and understandable diagrams

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade