Re: Too slow to create new schema and their tables, functions,triggers.

On 7/25/19 4:01 PM, PegoraroF10 wrote:
> Nope, no one message near those statements.
> I haven´t changed anything on Postgres.conf related with autovacuum.
> 

You probably should also look at this system view:

https://www.postgresql.org/docs/11/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW

to see what autovacuum activity has occurred on the tables.

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


-- 
Adrian Klaver
adrian.klaver@aklaver.com