zlacker
[parent]
[thread]
3 comments
1. ukd1+(OP)
[view]
[source]
2021-06-12 20:43:04
You really really wanna do everything (locking, working, unlocking, deleting or completing) in a transaction, and use SKIP LOCKED to find work. It's actually pretty high performance when you so this.
replies(1):
>>phumbe+w
◧
2. phumbe+w
[view]
[source]
2021-06-12 20:48:22
>>ukd1+(OP)
do you have a more detailed example on how this could look like?
replies(2):
>>taspeo+52
>>subleq+u7
◧◩
3. taspeo+52
[view]
[source]
[discussion]
2021-06-12 21:04:28
>>phumbe+w
The article starts by discussing SKIP LOCKED
◧◩
4. subleq+u7
[view]
[source]
[discussion]
2021-06-12 22:00:04
>>phumbe+w
https://github.com/gavinwahl/django-postgres-queue
[go to top]