Postgres Pro
Downloads
Home   >   mailing lists

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

From Adrian Klaver
Subject Re: Too slow to create new schema and their tables, functions,triggers.
Date
Msg-id 479a75d1-938f-0243-517a-3db26799fb07@aklaver.com
Whole thread Raw
In response to Re: Too slow to create new schema and their tables, functions,triggers.  (PegoraroF10 <marcos@f10.com.br>)
Responses Re: Too slow to create new schema and their tables, functions,triggers.  (PegoraroF10 <marcos@f10.com.br>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Too slow to create new schema and their tables, functions,triggers.
Next
From: Cyril Champier
Date:
Subject: Re: Default ordering option