Récits du Front

Posts taggés avec “Acid”
septembre 03, 2025
why-postgres-indexes-fail/postgres-logo.png

Most developers assume they know what READ COMMITTED, REPEATABLE READ, and SERIALIZABLE really mean, but PostgreSQL’s MVCC engine has a few surprises in store. This blog unpacks the real behavior behind each isolation level, exposes the anomalies they allow (and why), and shows how PostgreSQL bends the classic SQL-92 model in clever, performance-conscious ways. If you care about data consistency, concurrent transactions, or why SERIALIZABLE isn’t just a buzzword, this is the deep dive you didn’t know you needed.