2 ms·
Don't forget SKIP LOCKED[0]! [0]: https://blog.2ndquadrant.com/what-is-select-skip-locked-for-in-postgresql-9-5/ https://blog.2ndquadrant.com/what-is-select-sk
by hardwaresofton 5y ago
Don't forget SKIP LOCKED[0]!
[0]: https://blog.2ndquadrant.com/what-is-select-skip-locked-for-in-postgresql-9-5/ https://blog.2ndquadrant.com/what-is-select-skip-locked-for-...
- masklinn 5y ago`FOR UPDATE` is also a good idea.
- Koffiepoeder 5y agoThe article mentions that.. The comment by chx was rather a more generalized idea for implementing a queue that is not database-specific.