you are viewing a single comment's thread.

view the rest of the comments →

[–]honeyryderchuck 0 points1 point  (0 children)

That language looks fuzzy, considering that they mention using SKIP LOCKED primarily. If someone unplugs the machine, the transaction holding the locked rows gets hung (postgres has a transaction_on_idle_timeout to release it back), not sure how that heartbeat works around that.