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?