Autovacuum on sys tables

From: Inzamam Shafiq <inzamam(dot)shafiq(at)hotmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Autovacuum on sys tables
Date: 2022-12-17 07:15:46
Message-ID: AM9P251MB03301FB65BA063F541899F4098E79@AM9P251MB0330.EURP251.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Langille 2022-12-17 18:53:05 tsvector not giving expected results on one host
Previous Message David G. Johnston 2022-12-16 17:08:42 Re: Test if a database has any privilege granted to public