MIME-Version: 1.0
From: Lakshmi N <lakshmin.jhs@gmail.com>
Date: Fri, 10 Apr 2026 01:38:53 -0700
Message-ID: 
 <CA+3i_M9+A5Wx_o3d3UHcxVU_yfes+a1b8za4VgmWTY_Odc7qMA@mail.gmail.com>
Subject: Add missing CHECK_FOR_INTERRUPTS in autovacuum catalog scan loops
To: pgsql-hackers@lists.postgresql.org
Content-Type: multipart/mixed; boundary="000000000000d15bed064f1710fc"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2B3i_M9%2BA5Wx_o3d3UHcxVU_yfes%2Ba1b8za4VgmWTY_Odc7qMA%40mail.gmail.com>
Precedence: bulk

--000000000000d15bed064f1710fc
Content-Type: multipart/alternative; boundary="000000000000d15bea064f1710fa"

--000000000000d15bea064f1710fa
Content-Type: text/plain; charset="UTF-8"

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

--000000000000d15bea064f1710fa
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi hackers,<div><br></div><div>I noticed CFI is missing=C2=
=A0while scanning pg_class for RELKIND_RELATION and RELKIND_TOASTVALUE. On =
a database with several thousands of tables, these scans can take a noticea=
ble amount of time. Attached a patch to address this.</div><div><br></div><=
div>Regards,</div><div>Lakshmi</div></div>

--000000000000d15bea064f1710fa--

--000000000000d15bed064f1710fc
Content-Type: application/octet-stream; name="0001-autovacuum-cfi.patch"
Content-Disposition: attachment; filename="0001-autovacuum-cfi.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mnsnk7a90>
X-Attachment-Id: f_mnsnk7a90

ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvYXV0b3ZhY3V1bS5jIGIvc3JjL2Jh
Y2tlbmQvcG9zdG1hc3Rlci9hdXRvdmFjdXVtLmMKaW5kZXggODIwNjEyNDcuLjkwNTc1YTUyIDEw
MDY0NAotLS0gYS9zcmMvYmFja2VuZC9wb3N0bWFzdGVyL2F1dG92YWN1dW0uYworKysgYi9zcmMv
YmFja2VuZC9wb3N0bWFzdGVyL2F1dG92YWN1dW0uYwpAQCAtMjA0Miw2ICsyMDQyLDggQEAgZG9f
YXV0b3ZhY3V1bSh2b2lkKQogCQlib29sCQl3cmFwYXJvdW5kOwogCQlBdXRvVmFjdXVtU2NvcmVz
IHNjb3JlczsKIAorCQlDSEVDS19GT1JfSU5URVJSVVBUUygpOworCiAJCWlmIChjbGFzc0Zvcm0t
PnJlbGtpbmQgIT0gUkVMS0lORF9SRUxBVElPTiAmJgogCQkJY2xhc3NGb3JtLT5yZWxraW5kICE9
IFJFTEtJTkRfTUFUVklFVykKIAkJCWNvbnRpbnVlOwpAQCAtMjE0Niw2ICsyMTQ4LDggQEAgZG9f
YXV0b3ZhY3V1bSh2b2lkKQogCQlib29sCQl3cmFwYXJvdW5kOwogCQlBdXRvVmFjdXVtU2NvcmVz
IHNjb3JlczsKIAorCQlDSEVDS19GT1JfSU5URVJSVVBUUygpOworCiAJCS8qCiAJCSAqIFdlIGNh
bm5vdCBzYWZlbHkgcHJvY2VzcyBvdGhlciBiYWNrZW5kcycgdGVtcCB0YWJsZXMsIHNvIHNraXAg
J2VtLgogCQkgKi8K
--000000000000d15bed064f1710fc--