Re: Loading table with indexed jsonb field is stalling

Поиск
Список
Период
Сортировка
От Will Hartung
Тема Re: Loading table with indexed jsonb field is stalling
Дата
Msg-id 3EF519CA-17FE-4B68-8B7A-78200E0A408F@gmail.com
обсуждение исходный текст
Ответ на Re: Loading table with indexed jsonb field is stalling  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Loading table with indexed jsonb field is stalling  (Ron <ronljohnsonjr@gmail.com>)
Re: Loading table with indexed jsonb field is stalling  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
> On May 20, 2019, at 2:55 PM, Ron <ronljohnsonjr@gmail.com> wrote:

> And it pathologically loads even when there's just a PK on the numeric field?

Yea, that works fine.

> Drop all indexes, load data, recreate indexes?

No, I use the incremental load as it gives a much better indication when the process has gone off the deep end.

> But pg_restore only creates indexes AFTER the data loads.

Yes. Demonstrating that it doesn’t work either incrementally or all at once.

(No, I have no confidence that the Aurora build will ever finish in any reasonable amount of time.)





В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Loading table with indexed jsonb field is stalling
Следующее
От: Ron
Дата:
Сообщение: Re: Loading table with indexed jsonb field is stalling