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

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Too slow to create new schema and their tables, functions, triggers.
Дата
Msg-id CAHOFxGqqFKkS+zW_xJmXCrOnL9Te8axDBKVvh3msZ6othP3pyw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Too slow to create new schema and their tables, functions,triggers.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Too slow to create new schema and their tables, functions,triggers.
Следующее
От: Andres Freund
Дата:
Сообщение: Re: LWLock optimization