News for hackers. Stuff that matters.

A comment on Distributed locking with Postgres advisory locks. Parent comment

Re:Distributed locking with Postgres advisory locks by lucian1900 on Monday January 24, 2022 @04:27AM (#30055226)
Not only is that slow, but it raises errors programs aren’t currently handing. It would be incompatible to change.
[ Parent | on HN ]
Re:Distributed locking with Postgres advisory locks by belter on Monday January 24, 2022 @06:10AM (#30056102)
As opposed to the current default, that also raises errors programmers aren’t currently handing :-)
[ Parent | on HN ]
Re:Distributed locking with Postgres advisory locks by lucian1900 on Monday January 24, 2022 @06:27AM (#30056231)
The current default has effect anomalies, but doesn't raise serialization errors.

It's possible to write software that relies on READ COMMITTED and behaves correctly.

[ Parent | on HN ]