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

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.
>
> Basically, my script creates an entire structure for a new customer:
> - Create schema TempSchema; --just to be sure that nobody will connect until
> it finishes
> - create tables (100), constraints, functions, etc.
> - import data using restore only data.
> - rename TempSchema to production name.
>
> On second step, when creating tables, functions and so on, it takes
> sometimes a minute just to create one table or one function.

Can you show example of portion of script?

Have you looked at the Postgres log during the above to see if there any
relevant messages?

>
> So, does this happens because we have almost 200 schemas on that database ?
> I´m almost sure about.
> What do I need do to run my script as before ? Do I need to Reindex ? Vacuum
> ? Or am I reaching a limit in a number of schemas in a Postgres database ?
>
>
>
> --
> Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com