public inbox for [email protected]
help / color / mirror / Atom feedFrom: Sami Imseih <[email protected]>
To: Dapeng Wang <[email protected]>
Cc: Lakshmi N <[email protected]>
Cc: [email protected]
Subject: Re: Add missing CHECK_FOR_INTERRUPTS in autovacuum catalog scan loops
Date: Sat, 11 Apr 2026 15:10:42 -0500
Message-ID: <CAA5RZ0vCoWBmhKhoi3BKjn7SAkOsYUuO2y=iSh4sSn0q0BYS9Q@mail.gmail.com> (raw)
In-Reply-To: <CAKx0Yhzmn=gdfsv7iZDZ1cjXqRLq0amUmESL83qjyxnFDqYVJQ@mail.gmail.com>
References: <CA+3i_M9+A5Wx_o3d3UHcxVU_yfes+a1b8za4VgmWTY_Odc7qMA@mail.gmail.com>
<CAKx0YhxRYuWCSC3mCTJ0VRn0iM8v0G=7vku=3Wg7pyi+rN-=Jw@mail.gmail.com>
<CA+3i_M_Jwy2T+L+wT_4yXKG8r1yQFJt3+Gm5wbxap5hKyy_nzA@mail.gmail.com>
<CAKx0Yhzmn=gdfsv7iZDZ1cjXqRLq0amUmESL83qjyxnFDqYVJQ@mail.gmail.com>
Hi,
It was discussed [1] here if C_F_I is needed in these
do_autovacuum/autovacuum_scores code paths, and it
was decided not to add them.
Also, at least on my tests with 100k evern with 1 million tables, I did
not see a reason to do so. These are catalog scans that should
happen quick enough, even in extreme cases, to not make
this worthwhile.
Others may have another opinion.
--
Sami
[1] [https://www.postgresql.org/message-id/acwTxpz3Toxt0ty8%40nathan]
view thread (5+ messages)
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: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Add missing CHECK_FOR_INTERRUPTS in autovacuum catalog scan loops
In-Reply-To: <CAA5RZ0vCoWBmhKhoi3BKjn7SAkOsYUuO2y=iSh4sSn0q0BYS9Q@mail.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 agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox