News for hackers. Stuff that matters.

A comment on Postgres is a great pub/sub and job server (2019). Parent comment

Re:Postgres is a great pub/sub and job server (2019) by runeks on Saturday December 18, 2021 @08:48AM (#29604449)
So, just to make sure I understand correctly: notifications are delivered while the notification queue size is increasing (due to the transaction holding a lock), and it doesn’t become a problem until the queue size reaches its maximum, at which point it causes dropped notifications?

But the queue grows precisely because some notifications aren’t getting delivered, right?

[ Parent | on HN ]
Re:Postgres is a great pub/sub and job server (2019) by colinchartier on Saturday December 18, 2021 @11:36AM (#29605833)
Since it's pub/sub, you just need one misbehaving client that LISTENs in a transaction to have problems, the other clients can still receive and process the NOTIFY event
[ Parent | on HN ]