zlacker

[parent] [thread] 2 comments
1. andrew+(OP)[view] [source] 2023-09-25 01:51:31
Partial indexes might help.
replies(2): >>emilse+S9 >>runeks+pF1
◧
2. emilse+S9[view] [source] 2023-09-25 03:47:24
>>andrew+(OP)
Exactly. A partial index should make things fly here.
◧
3. runeks+pF1[view] [source] 2023-09-25 15:21:09
>>andrew+(OP)
Also: an ordered index that matches the ordering clause in your job-grabbing query. This is useful if you have lots of pending jobs.
[go to top]