Re: MultiXactId error after upgrade to 9.3.4 - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: MultiXactId error after upgrade to 9.3.4
Date
Msg-id 20140423193005.GS25695@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: MultiXactId error after upgrade to 9.3.4  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: MultiXactId error after upgrade to 9.3.4
List pgsql-hackers
Andres Freund wrote:

> I think this patch is a seriously bad idea. For one, it's not actually
> doing anything about the problem - the tuple can be accessed without
> freezing getting involved.

Normal access other than freeze is not a problem, because other code
paths do check for HEAP_XMAX_INVALID and avoid access to Xmax if that's
set.

> For another, it will increase wall traffic for freezing of short lived
> tuples considerably, without any benefit.

True.  I didn't actually try to run this; it was just for demonstration
purposes.  It'd need some cooperation from heap_tuple_needs_freeze in
order to work at all, for one thing.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: 9.4 Proposal: Initdb creates a single table
Next
From: Sergey Konoplev
Date:
Subject: Re: pg_upgrade and epoch