News for hackers. Stuff that matters.

A comment on River: A fast, robust job queue for Go and Postgres. Parent comment

Re:River: A fast, robust job queue for Go and Postgres by Rapzid on Tuesday November 21, 2023 @03:04AM (#38360757)
Probably order of magnitude more or perhaps a multiple of that depending on the hardware and design.

In theory an append-only and/or HOT strategy leaning on Postgres just ripping through moderate sized in-mem lists could be incredibly fast. Design would be more complicated and perhaps use case dependent but I bet could be done.

[ Parent | on HN ]
Re:River: A fast, robust job queue for Go and Postgres by qaq on Tuesday November 21, 2023 @09:25AM (#38364004)
Yep that's why I specifically mentioned "fairly modest instance" on reasonably fast box you can get magnitude more. You can partition the tasks table to reduce the number of rows skip locked has to run through to grab next task.
[ Parent | on HN ]