Re: Too slow to create new schema and their tables, functions,triggers. - Mailing list pgsql-general

On 7/26/19 4:15 AM, PegoraroF10 wrote:
> select count(*), count(*) filter (where last_autovacuum is not null) from
> pg_stat_all_tables
> count    count
> 36605    1178
> 
> But what tables should I see if vacuum ran on it ?

I would recommend reading this:

https://www.postgresql.org/docs/11/routine-vacuuming.html

and in particular:

https://www.postgresql.org/docs/11/routine-vacuuming.html#AUTOVACUUM

For now look at the actual values of last_autovacuum to see how current 
the autovacuuming is. My guess is that the issues you are having has to 
do with bloat in the system tables, so I would start there.

> 
> 
> 
> --
> Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com