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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: PegoraroF10 <marcos(at)f10(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org
Subject: Re: Too slow to create new schema and their tables, functions, triggers.
Date: 2019-07-26 03:09:47
Message-ID: 479a75d1-938f-0243-517a-3db26799fb07@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cyril Champier 2019-07-26 07:52:52 Re: Default ordering option
Previous Message Adrian Klaver 2019-07-25 23:44:57 Re: Too slow to create new schema and their tables, functions, triggers.