News for hackers. Stuff that matters.
Re:Demystifying Database Systems: An Introduction to Transac... by basetop on Friday May 03, 2019 @02:30PM (#19820990)
I'm not too familiar with postgresql, but isn't that serializable snapshot rather than serializable? I'm pretty sure all RDMBs have deadlocks in serializable. But in serialiable snapshot, a transaction doesn't deadlock, but simply fails.
Re:Demystifying Database Systems: An Introduction to Transac... by freels on Friday May 03, 2019 @03:57PM (#19821712)
Serializable Snapshot an implementation strategy for providing Serializable isolation. In PostgreSQL if you ask for Serializable you get SSI.
Re:Demystifying Database Systems: An Introduction to Transac... by convolvatron on Friday May 03, 2019 @02:52PM (#19821197)
a transaction system in which its impossible for transactions to ever fail kind of isn't a transaction system.

see above comment from abadid - its entirely possible to impose a global ordering of all transactions either up front or retroactively without admitting deadlocks.