Re: Add missing CHECK_FOR_INTERRUPTS in autovacuum catalog scan loops

From: Sami Imseih <samimseih(at)gmail(dot)com>
To: Dapeng Wang <wangdp20191008(at)gmail(dot)com>
Cc: Lakshmi N <lakshmin(dot)jhs(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add missing CHECK_FOR_INTERRUPTS in autovacuum catalog scan loops
Date: 2026-04-11 20:10:42
Message-ID: CAA5RZ0vCoWBmhKhoi3BKjn7SAkOsYUuO2y=iSh4sSn0q0BYS9Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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]

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Shlok Kyal 2026-04-11 19:02:40 Re: Support EXCEPT for ALL SEQUENCES publications