News for hackers. Stuff that matters.
Re:Postgres transactions are a distributed systems superpower by mrkeen on Thursday July 02, 2026 @06:08PM (#48768006)
Step 1: identify that you and at least one other node are separated by distance, and some lossy communication channel, and therefore form a distributed system.

Step 2: propose a source of truth that everyone can listen to. Hearing the same facts in the same order should put everyone in the same state (eventual consistency)

Step 3 (you are here): try to do better than EC, by merging the external queue into one of the nodes, making it the master.

Step 4: Now there's no distance between the nodes, so no need to solve the distributed systems problem and you can retire the queue.

Re:Postgres transactions are a distributed systems superpower by convolvatron on Thursday July 02, 2026 @06:42PM (#48768320)
eventual consistency as generally used doesn't guarantee that events are presented in the same order. I use 'monotonic consistency' for that, but idk how common that is.
Re:Postgres transactions are a distributed systems superpower by AlotOfReading on Thursday July 02, 2026 @08:07PM (#48769039)
Order independence/monotonicity is strong EC rather than regular EC.
Re:Postgres transactions are a distributed systems superpower by mrkeen on Thursday July 02, 2026 @06:45PM (#48768352)
Yes, same-ordering gives you EC, not the other round.