Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput
Date
Msg-id da929709-e590-4c1f-a73d-787df23f447f@app.fastmail.com
Whole thread Raw
In response to Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput  (Rishu Bagga <rishu.postgres@gmail.com>)
List pgsql-hackers
On Fri, Jul 18, 2025, at 02:49, Rishu Bagga wrote:
> Hi all,
>
> There’s been some renewed attention on improving the performance of the
> LISTEN/NOTIFY system, which historically hasn’t scaled well under high
> notify frequency. Joel Jacobson recently shared some work on optimizing
> the LISTEN path [1], and I wanted to follow up with a proposal focused on
> the NOTIFY side.

To clarify, my patch optimizes parallelizability of NOTIFY, without degrading parallelizability of LISTEN/UNLISTEN.

/Joel



pgsql-hackers by date:

Previous
From: Rintaro Ikeda
Date:
Subject: Re: Suggestion to add --continue-client-on-abort option to pgbench
Next
From: Robins Tharakan
Date:
Subject: Re: leafhopper / snakefly failing to build HEAD - GCC bug