Re: MultiXact\SLRU buffers configuration - Mailing list pgsql-hackers

From Andrey M. Borodin
Subject Re: MultiXact\SLRU buffers configuration
Date
Msg-id D48EEBE4-0BD8-4503-8738-1E9E069A3970@yandex-team.ru
Whole thread Raw
In response to Re: MultiXact\SLRU buffers configuration  (Thom Brown <thom@linux.com>)
List 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 by date:

Previous
From: Aleksander Alekseev
Date:
Subject: Re: Remove an obsolete comment in gistinsert()
Next
From: Andreas Karlsson
Date:
Subject: Re: Always have pg_dump write rules in a consistent order