← Back to context Comment by andrewstuart 3 years ago Partial indexes might help. 2 comments andrewstuart Reply runeks 3 years ago Also: an ordered index that matches the ordering clause in your job-grabbing query. This is useful if you have lots of pending jobs. emilsedgh 3 years ago Exactly. A partial index should make things fly here.
runeks 3 years ago Also: an ordered index that matches the ordering clause in your job-grabbing query. This is useful if you have lots of pending jobs.
Also: an ordered index that matches the ordering clause in your job-grabbing query. This is useful if you have lots of pending jobs.
Exactly. A partial index should make things fly here.