Re:Choose Postgres Queue Technology
by valzam on Sunday September 24, 2023 @08:34PM
(#37638481)
The reason why you want to use skip locked is so that Postgres can automatically skip rows that are being concurrently accessed for updating the "status". You are right, if you update a "status" field you don't really need to worry about advisory locks and skipping rows that are locked but it still helps with performance if you have a decent amount of concurrent consumers polling the table.
[ Parent
| on HN ]
There are no comments on this comment yet.