This week I learned more than I'd ever thought I'd know about transaction isolation in Postgres
@metasyn I was trying to figure out how to maintain an atomic counter column.
I initially started out using Serializable isolation, but after a lot of debugging it turned out that what I actually wanted was Repeatable Read isolation.
Turns out, Serializable isolation performs page-level locking, so you can run into scenarios where concurrent updates to different rows in a table can fail if they are on the same page.
Merveilles is a community project aimed at the establishment of new ways of speaking, seeing and organizing information — A culture that seeks augmentation through the arts of engineering and design. A warm welcome to any like-minded people who feel these ideals resonate with them.