Some time ago, I wrote blogpost about how to pick a task from queue, without locking. It was written in 2013, and as such it couldn't reflect everything we have now in PostgreSQL - namely SKIP LOCKED - which was added ...

There is new blogpost on this subject! There are cases where system stores list of things to do, and then there are some worker processes that check the list, pick something to work on, do it, and remove from the list. Proper ...

On 18th of February, Itagaki Takahiro committed patch: Add transaction-level advisory locks.   They share the same locking namespace with the existing session-level advisory locks, but they are automatically released at the end of the current transaction and cannot be released explicitly via unlock functions.   Marko Tiikkaja, ...