Re: Notifications within triggers seem to compromise performance

Le 28/10/2019 à 17:25, Tom Lane a écrit : =?UTF-8?Q?Gr=c3=a9goire_de_Turckheim?= writes: Le 28/10/2019 à 15:22, Tom Lane a écrit : We made some performance improvements for NOTIFY just a couple months ago, cf commits b10f40bf0, bb5ae8f6c, bca6e6435, 51004c717. It would be interesting to know

Re: Notifications within triggers seem to compromise performance

=?UTF-8?Q?Gr=c3=a9goire_de_Turckheim?= writes: > Le 28/10/2019 à 15:22, Tom Lane a écrit : >> We made some performance improvements for NOTIFY just a couple months >> ago, cf commits b10f40bf0, bb5ae8f6c, bca6e6435, 51004c717. It would >> be interesting to know how much those changes helped your

Re: Notifications within triggers seem to compromise performance

Le 28/10/2019 à 15:22, Tom Lane a écrit : =?UTF-8?Q?Gr=c3=a9goire_de_Turckheim?= writes: I guess we stumbled upon a performance issue with notifications sent within triggers (using PostgreSQL version 11.5) and I'd like your opinion about this. We made some performance improvements for NOTIFY

Re: Notifications within triggers seem to compromise performance

=?UTF-8?Q?Gr=c3=a9goire_de_Turckheim?= writes: > I guess we stumbled upon a performance issue with notifications sent within > triggers (using PostgreSQL version 11.5) > and I'd like your opinion about this. We made some performance improvements for NOTIFY just a couple months ago, cf commits b1