pg.ddx.io pgsql-hackers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Matheus Alcantara <matheusssilv97@gmail.com>
To: Rishu Bagga <rishu.postgres@gmail.com>
To: Arseniy Mukhin <arseniy.mukhin.dev@gmail.com>
Cc: Yura Sokolov <y.sokolov@postgrespro.ru>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: Daniil Davydov <3danissimo@gmail.com>
Cc: Álvaro Herrera <alvherre@kurilemu.de>
Cc: Alexandra Wang <alexandra.wang.oss@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Joel Jacobson <joel@compiler.org>
Subject: Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue
Date: Fri, 05 Sep 2025 07:45:32 -0300
Message-ID: <DCKT0VWL4B34.N09V46RR5QV9@gmail.com> (raw)
In-Reply-To: <CAK80=jjBampxwFJkS1k7qMNHB6eK8-hBWbKiCFJU-XV8o_QwDQ@mail.gmail.com>
References: <CAK98qZ3wZLE-RZJN_Y+TFjiTRPPFPBwNBpBi5K5CU8hUHkzDpw@mail.gmail.com>
<202508061044.ptcyt7aqsaaa@alvherre.pgsql>
<DBZN3PVLZ1UW.25XLKCUXYBVXV@gmail.com>
<CAJDiXgg1ArRB1-6wLtXfVVnQ38P9Y+CDfEc9M2TXiOf_4kfBMg@mail.gmail.com>
<CAFY6G8cnDOMZCfSvc62vER_9+HOs4EM52XromhOZki+=Ytv2sg@mail.gmail.com>
<CAJDiXgheRHTnK8RJuBBcF0VjQA83wi81oX2s-GvBV3x+eSwBbA@mail.gmail.com>
<CAFY6G8dyimRikP3nEK5gqMPnMZe5RTZjFvKvCFLJAvsajxK1fg@mail.gmail.com>
<CAJDiXgjQZgHLFziG6sS6D5CGYqohMio673ydiRkkffW3WfXmEg@mail.gmail.com>
<DC7KGTXW3QSG.OZA24HONT78J@gmail.com>
<CAD21AoCD+HXoc2QZCAS9d8ahDeikNqbnU0i6cQzpMFOEurkPPg@mail.gmail.com>
<DC8HKDZVIDYG.12H0X267CHMO5@gmail.com>
<CAFY6G8cJm73_MM9SuynZUqtqcaTuepUDgDuvS661oLW7U0dgsg@mail.gmail.com>
<d186fba0-dc65-4274-aa96-3906bbb2e530@postgrespro.ru>
<CAE7r3M+Xwf0A_aNhu7pYQd7nDQaqaEnyCjtvqg8XsgManmPOUA@mail.gmail.com>
<DCJH5HX8X3B4.O9P9P8VKKO1F@gmail.com>
<CAK80=jhxduhJmgSWY8JK4Aen8qshPGHFLE-J_ix6EN9AK6+sQQ@mail.gmail.com>
<CAE7r3M+p=YzizrO2t-WWWhqaaeryMUMa3ChGirh=g8KCLaF5aA@mail.gmail.com>
<CAK80=jjBampxwFJkS1k7qMNHB6eK8-hBWbKiCFJU-XV8o_QwDQ@mail.gmail.com>
On Thu Sep 4, 2025 at 8:02 PM -03, Rishu Bagga wrote:
> On Thu, Sep 4, 2025 at 7:14 AM Arseniy Mukhin
> <arseniy.mukhin.dev@gmail.com> wrote:
>
>> Interesting, have you shared your patch and results somewhere? IIUC
>> Tom's approach resolves this bug, because with it we have queue
>> entries produced by committed transactions only, so we don't need to
>> check their status and don't have dependency on clog.
>
> I was eventually able to get better numbers with the patch after using
> a substantial number of connections, so I have now posted it here. [1].
>
Thanks for sharing the patch! I'll reserve some time to test and review.
--
Matheus Alcantara
view thread (99+ messages) latest in thread
Message-ID: <DCKT0VWL4B34.N09V46RR5QV9@gmail.com> Permalink: ../DCKT0VWL4B34.N09V46RR5QV9@gmail.com/ Also on: postgresql.org/message-id/DCKT0VWL4B34.N09V46RR5QV9@gmail.com ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-hackers@postgresql.org Cc: matheusssilv97@gmail.com, rishu.postgres@gmail.com, arseniy.mukhin.dev@gmail.com, y.sokolov@postgrespro.ru, sawada.mshk@gmail.com, 3danissimo@gmail.com, alvherre@kurilemu.de, alexandra.wang.oss@gmail.com, tgl@sss.pgh.pa.us, joel@compiler.org Subject: Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue In-Reply-To: <DCKT0VWL4B34.N09V46RR5QV9@gmail.com> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox