Re:Show HN: Transform Your PostgreSQL into a Powerful Job Queue
by collingreen on Tuesday August 20, 2024 @10:24AM
(#41300356)
Without more logic than this does this mean any workers that are busy or down mean you lose jobs?
Re:Show HN: Transform Your PostgreSQL into a Powerful Job Queue
by airocker on Tuesday August 20, 2024 @10:52AM
(#41300615)
We use a garbage collector to error restart if a job is not served within a specified amount of time.
Re:Show HN: Transform Your PostgreSQL into a Powerful Job Queue
by airocker on Tuesday August 20, 2024 @10:51AM
(#41300611)
Great observation, I wrote a little wrongly. What we want ideally is guaranteed delivery to one random free worker. Uuid strategy is better than locking but this could mean that if one worker gets a longer job, all the others on this worker are delayed even if another worker is free.
Ex. you have two consumers, if the sequence number is odd, A picks it, if its even B picks.