| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andrew Smith <laconical(at)gmail(dot)com> |
| Cc: | Rita <rmorgan466(at)gmail(dot)com>, Brian Dunavant <dunavant(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Listen/Notify feedback |
| Date: | 2020-07-12 14:16:52 |
| Message-ID: | 2501819.1594563412@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Andrew Smith <laconical(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rita | 2020-07-12 15:50:18 | Re: Listen/Notify feedback |
| Previous Message | Andrew Smith | 2020-07-12 12:52:30 | Re: Listen/Notify feedback |