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

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