Request a Demo
Home   >   mailing lists

Add missing CHECK_FOR_INTERRUPTS in autovacuum catalog scan loops - Mailing list pgsql-hackers

From Lakshmi N
Subject Add missing CHECK_FOR_INTERRUPTS in autovacuum catalog scan loops
Date
Msg-id CA+3i_M9+A5Wx_o3d3UHcxVU_yfes+a1b8za4VgmWTY_Odc7qMA@mail.gmail.com
Whole thread
Responses Re: Add missing CHECK_FOR_INTERRUPTS in autovacuum catalog scan loops
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

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