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

From Michael Lewis
Subject Re: Too slow to create new schema and their tables, functions, triggers.
Date
Msg-id CAHOFxGqqFKkS+zW_xJmXCrOnL9Te8axDBKVvh3msZ6othP3pyw@mail.gmail.com
Whole thread Raw
In response to Re: Too slow to create new schema and their tables, functions,triggers.  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Tue, Jul 23, 2019 at 1:36 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 7/23/19 12:20 PM, PegoraroF10 wrote:
> We have in a single database 190 identical schemas. Now, when we create a new
> one, with exactly same structure as the previous ones, it takes 20 or 30
> minutes to finish. Usual time to finish that script was 30 seconds.

 Can you create 200 schemas using your script without the data load step and reproduce the issue? With 19,000 tables on that database, how aggressive is autovacuum?

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Too slow to create new schema and their tables, functions,triggers.
Next
From: Andres Freund
Date:
Subject: Re: LWLock optimization