Choose Postgres Queue Technology

Re:Choose Postgres Queue Technology by vore on Sunday September 24, 2023 @09:48PM (#37638868)

You have no ordering guarantees, so how can order be important? If 4 work items are scheduled on 4 independent workers, you have no guarantee which will start first or finish first.

[ Parent | on HN ]

Re:Choose Postgres Queue Technology by nsonha on Sunday September 24, 2023 @10:33PM (#37639080)

The order matters in the sense that the 5th jobs should not be atempted before those 4.

[ Parent | on HN ]

Re:Choose Postgres Queue Technology by riku_iki on Monday September 25, 2023 @12:49AM (#37639768)

I think the order matter at least because you want to have some FIFO approximation, otherwise some tasks can forever stuck in queue and never be picked up.

[ Parent | on HN ]

Re:Choose Postgres Queue Technology by vore on Monday September 25, 2023 @03:07AM (#37640467)

Then I think what you actually care about is scheduling fairness, and a strict ordering of execution of job 5 after job 4 is unimportant.

[ Parent | on HN ]