Re: Autovacuum on sys tables

Поиск
Список
Период
Сортировка
От Thomas Boussekey
Тема Re: Autovacuum on sys tables
Дата
Msg-id CALUeYmcZixsxCq7aU=Pb+AVkUGgR5y+WYf5h=EcivtinoWQymg@mail.gmail.com
обсуждение исходный текст
Ответ на Autovacuum on sys tables  (Inzamam Shafiq <inzamam.shafiq@hotmail.com>)
Ответы Re: Autovacuum on sys tables  (Inzamam Shafiq <inzamam.shafiq@hotmail.com>)
Список pgsql-general
Hello Inzamam,

Le sam. 17 déc. 2022 à 08:16, Inzamam Shafiq <inzamam.shafiq@hotmail.com> a écrit :
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?

pg_repack cannot run on system tables, it will FAIL with an explicit error message explaining the limitation.

Each time you perform DDL operations (CREATE, DROP, ALTER), rows are inserted/updated or deleted into the system tables : pg_class, pg_attribute ...
Autovacuum operations perform "low-level" operations, it can be interesting to perform "middle-level" vacuum with VACUUM ANALYZE... that is not blocking, but will be more a resource-consuming operation than autovacuum.

Performing VACUUM FULL operation will block access to these pillar tables of your database. 
If your application/users can handle it, go ahead! 
At work on this kind of operation, I set a statement_timeout, in order to properly stop the process if it is over a defined amount of time.

Hope this helps,
Thomas

Thank you.

Regards,

Inzamam Shafiq
Sr. DBA

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: integer square root function proposed
Следующее
От: Inzamam Shafiq
Дата:
Сообщение: Re: Autovacuum on sys tables