Correct, seems to be something wrong on system tables. Maybe our script is
running something is already there, we will check.
select * from pg_stat_sys_tables where schemaname = 'pg_catalog'
relname n_live_tup n_dead_tup
pg_attrdef 3699 1095
pg_index 4756 1183
pg_sequence 20827 1482
pg_statistic 171699 27101
pg_trigger 221319 20718
pg_shdepend 225017 22337
pg_attribute 883023 164153
pg_depend 1553586 142960
and all them last_vacuum is null and last_autovacuum is too old.
So, is it better to configure autovacuum properly to these tables or should
I run vacuum periodically ?
Obviously I´ll check our script too.
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html