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 18481dfb-af39-b6a2-7b27-88563cab7134@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
On 7/24/19 11:33 AM, PegoraroF10 wrote:
> I did not have vacuumed or reindexed my database for last 30 days and that
> was my problem.

Autovacuum should be dealing with this.

Do you have it throttled in some manner?

> It works fine if I do a reindex database before adding that new schema.
> Well, I´ll try just reindexing system before adding a new schema to see if
> it works.
> 
> 
> 
> 
> 
> --
> Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: PegoraroF10
Date:
Subject: Re: Too slow to create new schema and their tables, functions,triggers.
Next
From: Souvik Bhattacherjee
Date:
Subject: Re: Running concurrent txns and measuring the timings in Postgres