Re: Loading table with indexed jsonb field is stalling

Поиск
Список
Период
Сортировка
От Will Hartung
Тема Re: Loading table with indexed jsonb field is stalling
Дата
Msg-id 52ACFC7C-47B8-4BF1-BDF1-8810F02BD297@gmail.com
обсуждение исходный текст
Ответ на Re: Loading table with indexed jsonb field is stalling  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Loading table with indexed jsonb field is stalling  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Loading table with indexed jsonb field is stalling  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
> On May 20, 2019, at 5:14 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> Well looks like you are down to Tom's suggestion of creating a test case. Given that it seems confined to the jsonb
fieldand corresponding index, I would think that is all that is needed for the test case. Start with some smaller
subset,say 10,000 rows and work up till you start seeing an issue. 

This will take quite some work, and I wouldn’t attempt it with less than 5M rows to load.





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

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