Re: Loading table with indexed jsonb field is stalling

Поиск
Список
Период
Сортировка
От Will Hartung
Тема Re: Loading table with indexed jsonb field is stalling
Дата
Msg-id 36F908DB-2F04-44F8-8C2E-7FD630882E0E@gmail.com
обсуждение исходный текст
Ответ на Re: Loading table with indexed jsonb field is stalling  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> On May 20, 2019, at 11:12 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Hmm, so not a deadlock (plus you're running a version that has that
> bug fixed).  It sounds like you might have hit an actual bug, perhaps
> one that causes it to endlessly re-split an index page, or something
> along that line.  But it's going to be hard to find the cause without
> a test case.  I don't suppose you can anonymize your data to the
> point where you'd have a publishable test case?

That would take some time, thankfully it seems reproducible with a few million rows.

I’ve moved the files around a little bit (not aggressively) and it still stalled, so I don’t think it’s something
specificto the data. But we’ll have to play with it and see. 

Thanks.




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

Предыдущее
От: Will Hartung
Дата:
Сообщение: Re: Loading table with indexed jsonb field is stalling
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: INSERT where not exists with foreign key