Re: MultiXact\SLRU buffers configuration

Поиск
Список
Период
Сортировка
От Andrey M. Borodin
Тема Re: MultiXact\SLRU buffers configuration
Дата
Msg-id D48EEBE4-0BD8-4503-8738-1E9E069A3970@yandex-team.ru
обсуждение исходный текст
Ответ на Re: MultiXact\SLRU buffers configuration  (Thom Brown <thom@linux.com>)
Список pgsql-hackers

> On 1 Nov 2024, at 00:25, Thom Brown <thom@linux.com> wrote:
>
> Unfortunately I didn't gather much information when it was occuring, and prioritised getting rid of the process
blockingreplay. I just attached gdb to it, got a backtrace and then "print ProcessInterrupts()". 
>

Currently I do not see how this wait can result in a deadlock.
But I did observe standby in a pathological sequential scan encountering recent multixact again and again (new each
time).
I hope this situation will be alleviated by recent cahnges - now there is not a millisecond wait, but hopefully smaller
amountof time. 

In v17 we also added injection point test which reproduces reading very recent multixact. If there is a deadlock I hope
buildfarmwill show it to us. 


Best regards, Andrey Borodin.


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