Re: pgsql: Fix a couple of bugs in MultiXactId freezing

Noah Misch <noah(at)leadboat(dot)com> writes:
> On Tue, Dec 03, 2013 at 07:26:38PM +0100, Andres Freund wrote:
>> On 2013-12-03 13:14:38 -0500, Noah Misch wrote:
>>> On Tue, Dec 03, 2013 at 04:37:58PM +0100, Andres Freund wrote:
>>>> I currently don't see fixing the errorneous freezing of lockers (not the
>>>> updater though) without changing the wal format or synchronously waiting
>>>> for all lockers to end. Which both see like a no-go?
>
>>> Not fixing it at all is the real no-go. We'd take both of those undesirables
>>> before just tolerating the lost locks in 9.3.

>> I think it's changing the wal format then.

> I'd rather have an readily-verifiable fix that changes WAL format than a
> tricky fix that avoids doing so. So, modulo not having seen the change, +1.

Yeah, same here.

After some discussion, the core committee has concluded that we should go
ahead with the already-wrapped releases. 9.2.6 and below are good anyway,
and despite this issue 9.3.2 is an improvement over 9.3.1. We'll plan to
do a 9.3.3 as soon as the multixact situation can be straightened out;
but let's learn from experience and not try to fix it in a panic.

regards, tom lane