Re:System design hack: Postgres is a great pub/sub and job s...
by disiplus on Friday November 08, 2019 @03:29PM
(#21486379)
at this point why not use something like rabbitmq and not reinvent it in postgres.
[ Parent
| on HN ]
Re:System design hack: Postgres is a great pub/sub and job s...
by stickfigure on Friday November 08, 2019 @03:47PM
(#21486542)
Because it's trivially easy. The dequeue operation updates the last_lease time; the query makes sure you don't dequeue something that was recently leased. It's far, far easier than setting up a separate job queue, especially if you are already using an RDBMS.