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

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: PegoraroF10 <marcos(at)f10(dot)com(dot)br>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Too slow to create new schema and their tables, functions, triggers.
Date: 2019-07-23 19:46:36
Message-ID: CAHOFxGqqFKkS+zW_xJmXCrOnL9Te8axDBKVvh3msZ6othP3pyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 23, 2019 at 1:36 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2019-07-23 19:53:39 Re: LWLock optimization
Previous Message Adrian Klaver 2019-07-23 19:36:18 Re: Too slow to create new schema and their tables, functions, triggers.