zlacker

[return to "Choose Postgres queue technology"]
1. MattIP+Zo[view] [source] 2023-09-25 00:13:26
>>bo0tzz+(OP)
We process around 1 million events a day using a queue like this in Postgres, and have processed over 400 million events since the system this is used in went live. Only issue we've had was slow queries due to the table size, as we keep an archive of all the events processed, but some scheduled vacuums every so often kept that under control.
◧◩
2. andrew+Vw[view] [source] 2023-09-25 01:51:31
>>MattIP+Zo
Partial indexes might help.
◧◩◪
3. runeks+kc2[view] [source] 2023-09-25 15:21:09
>>andrew+Vw
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]