Re: NOTIFY and pg_notify performance when deduplicating notifications

From: Catalin Iacob <iacobcatalin(at)gmail(dot)com>
To: julien(at)jdemoor(dot)com
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: NOTIFY and pg_notify performance when deduplicating notifications
Date: 2018-10-05 15:47:36
Message-ID: CAHg_5goMB8TJLBSB=sK9cX2CQhi=TtzGW1Ph47yev+yVgAqgyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Oct 2, 2018 at 7:20 PM <julien(at)jdemoor(dot)com> wrote:
> I have a feature built around LISTEN / NOTIFY that works perfectly well, except for the enormous performance impact to transactions 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/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-10-05 15:54:59 Re: Performance improvements for src/port/snprintf.c
Previous Message Alvaro Herrera 2018-10-05 15:41:29 Re: Assertion failure with ALTER TABLE ATTACH PARTITION with log_min_messages >= DEBUG1