←back to thread

Locks in PostgreSQL: 3. Other locks (2020)

(habr.com)
60 points fanf2 | 1 comments | 07 Dec 25 15:42 UTC | HN request time: 0.396s | source
Show context
semiquaver ◴[07 Dec 25 16:06 UTC] No.46182699[source]▶
Don’t skip the discussion on advisory locks. In my experience nearly every nontrivial application that spans multiple machines has concurrency bugs that advisory locks are perfectly suited to fix.
replies(4): >>46183073 #>>46183165 #>>46183758 #>>46183971 #
1. leftnode ◴[07 Dec 25 16:51 UTC] No.46183073[source]▶
Yes! Just implemented these the other day for a long running process that I didn't want to lock a specific row for.