Postgres Pro
Downloads
Home   >   mailing lists

Re: NOTIFY and pg_notify performance when deduplicating notifications - Mailing list pgsql-hackers

From Catalin Iacob
Subject Re: NOTIFY and pg_notify performance when deduplicating notifications
Date
Msg-id CAHg_5goMB8TJLBSB=sK9cX2CQhi=TtzGW1Ph47yev+yVgAqgyA@mail.gmail.com
Whole thread Raw
In response to NOTIFY and pg_notify performance when deduplicating notifications  (<julien@jdemoor.com>)
Responses RE: NOTIFY and pg_notify performance when deduplicating notifications  (<julien@jdemoor.com>)
List pgsql-hackers
Tree view 
On Tue, Oct 2, 2018 at 7:20 PM <julien@jdemoor.com> wrote:
> I have a feature built around LISTEN / NOTIFY that works perfectly well, except for the enormous performance impact
totransactions that emit large numbers of notifications.
 

Indeed, I have the same and am very interested in this.

> I hope this patch can be reviewed and included in PostgreSQL.

I added this to the next Commitfest and added myself as a reviewer.
Will try to a review beginning of next week.
https://commitfest.postgresql.org/20/1820/

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Assertion failure with ALTER TABLE ATTACH PARTITION withlog_min_messages >= DEBUG1
Next
From: Tom Lane
Date:
Subject: Re: Performance improvements for src/port/snprintf.c