Add missing CHECK_FOR_INTERRUPTS in autovacuum catalog scan loops

From: Lakshmi N <lakshmin(dot)jhs(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Add missing CHECK_FOR_INTERRUPTS in autovacuum catalog scan loops
Date: 2026-04-10 08:38:53
Message-ID: CA+3i_M9+A5Wx_o3d3UHcxVU_yfes+a1b8za4VgmWTY_Odc7qMA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers,

I noticed CFI is missing while scanning pg_class for RELKIND_RELATION and
RELKIND_TOASTVALUE. On a database with several thousands of tables, these
scans can take a noticeable amount of time. Attached a patch to address
this.

Regards,
Lakshmi

Attachment Content-Type Size
0001-autovacuum-cfi.patch application/octet-stream 639 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Evgeny Voropaev 2026-04-10 08:44:07 Re: Compress prune/freeze records with Delta Frame of Reference algorithm
Previous Message Thomas Munro 2026-04-10 08:14:07 Re: Trying out libarchive for reading user-generated WAL tarballs