Re: MultiXact pessmization in 9.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: MultiXact pessmization in 9.3
Date: 2013-11-27 23:29:00
Message-ID: 9563.1385594940@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andres Freund <andres(at)2ndquadrant(dot)com> writes:
> On 2013-11-27 19:24:35 -0300, Alvaro Herrera wrote:
>> The other idea is to just not backpatch this.

> I think backpatching is a good idea, I have seen GetMultiXactIdMembers()
> + slru code take up 80% cpu in strange workloads. But it possibly might
> be a good idea to wait till after the next point release to give people
> at least a minimal chance of catching problems.

Agreed on both counts. We're close enough now to Monday's wrap that we
should avoid anything that risks destabilizing 9.3.x, unless it's to fix
a serious bug. AIUI this is just a performance issue, so let's wait till
after 9.3.2 is done to push in the fix. But since it is a performance
regression from pre-9.3, never back-patching the fix at all isn't very
attractive.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2013-11-27 23:36:12 Re: [GENERAL] pg_upgrade ?deficiency
Previous Message Andres Freund 2013-11-27 23:24:08 Re: MultiXact bugs