Re: Listen/Notify feedback

Andrew Smith <laconical@gmail.com> writes:
> A couple of years ago I started looking into listen/notify in PG10 and
> found that the throughput decreased quite a bit as I added more and more
> listeners. Given the number of apps I needed to have listening and the
> number of messages that I expected to be consuming, I ended up writing a
> single listener app which then republished the messages via MQTT. Not sure
> if the performance has improved in subsequent versions (or whether this
> will affect you at all) but it's something to keep in mind.

FWIW, we made some efficiency improvements in v13 for the case of NOTIFY
with a lot of listeners [1].  Can't say of course whether that would
have fixed your problem, and v13 is still in beta anyway.

            regards, tom lane

[1] https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=51004c717