Horton
Menu

Autovacuum on sys tables

Inzamam Shafiq <inzamam.shafiq@hotmail.com>

View thread
From: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2022-12-17T07:15:46Z
Lists: pgsql-general 
Dear Experts,

Hope you are doing well.

I have a question that autovacuum is running on sys tables like pg_class, pg_attribute, is it a normal thing? Further, what is dead tuples are not removed from Autovacuum, can we remove the dead tuples using FULL VACUUMM or pg_repack on sys tables?

Thank you.

Regards,

Inzamam Shafiq
Sr. DBA