3 ms·
I think these slides describe it best. https://www.pgcon.org/2016/schedule/attachments/414_queues-pgcon-2016.pdf https://www.pgcon.org/2016/schedule/attachments
by renesd 10y ago
I think these slides describe it best. https://www.pgcon.org/2016/schedule/attachments/414_queues-pgcon-2016.pdf https://www.pgcon.org/2016/schedule/attachments/414_queues-p... Page 34. The key is SKIP LOCKED, so you do not try and grab an item off the queue which is already locked.
- gbrits 10y agoThanks. Reading the 'problems' section: a simple solution for "Resilience against crashing or hanging workers" would be having a TTL on the lock. If only...