HNGlance

Top Best New Show

PostgreSQL 12.3 Jepsen Analysis (2020)

https://jepsen.io/analyses/postgresql-12.3

by refset • 2 years ago

1 1 2 years ago

JE

Related Stories

Loading related stories...

Comments

1

refset• 2 years ago

I was surprised that this Jepsen report has never been discussed here before, but it really captures just how problematic the history of 'safe' database isolation levels has been. Some excerpts:

For the last nine years, PostgreSQL’s “serializable” mode has justifiably claimed to offer serializability.
[but] PostgreSQL’s “serializable” isolation level isn’t serializable: it allows G2-item during normal operation
[...] These cycles are precisely what PostgreSQL’s SSI implementation is meant to prevent!
This code has gone essentially untouched since the introduction of serializable snapshot isolation in 2011.

Making things appear to be serializable is really hard.

Source preview

jepsen.io

HNGlance

© 2024-2026 HN Glance. Story content belongs to its original sources.

Privacy
Terms