Andrew Smith <laconical@xxxxxxxxx> 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
