Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput

Masahiko Sawada <sawada.mshk@gmail.com>

From: Masahiko Sawada <sawada.mshk@gmail.com>

To: Arseniy Mukhin <arseniy.mukhin.dev@gmail.com>

Cc: Matheus Alcantara <matheusssilv97@gmail.com>, Rishu Bagga <rishu.postgres@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Joel Jacobson <joel@compiler.org>, pgsql-hackers <pgsql-hackers@postgresql.org>, "nik@postgres.ai" <nik@postgres.ai>

Date: 2025-09-12T18:03:37Z

Lists: pgsql-hackers

On Wed, Sep 10, 2025 at 12:00 PM Arseniy Mukhin
<arseniy.mukhin.dev@gmail.com> wrote:
>
>
> 6) We have fixed size queue entries, so I think we don't need this
> "padding" logic at the end of the page anymore, because we know how
> many entries we can have on each page.

+1

Probably we also no longer need to have a pair of page number and
offset number as an entry queue's position since AsyncQueueEntry is
now a fixed size.

> BTW, what do you think about creating a separate thread for the patch?
> The current thread's subject seems a bit irrelevant.

+1

Regards,

-- 
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com