Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring
Дата
Msg-id 578150.1604274357@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring  (Andrey Borodin <x4mmm@yandex-team.ru>)
Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring  (Tom Vijlbrief <tvijlbrief@gmail.com>)
Список pgsql-bugs
> PG Bug reporting form <noreply@postgresql.org> writes:
>> This looks to me like a low level issue with Postgres13 and TOAST objects of
>> a specific size and or compression behavior.

After looking at it some more, I'm pretty sure that these issues could
explain your problem, though it's possible there's an additional
contributing issue.  If you're in a position to apply a patch and
see whether it fixes the problem, please try

https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=2330f4d3a87ac43b6ecd31bfd698384888ed03cb

            regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring
Следующее
От: Andrey Borodin
Дата:
Сообщение: Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring