Re: multixact optimization patches - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: multixact optimization patches
Date
Msg-id 20141012014008.GS7043@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: multixact optimization patches  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian wrote:
> On Tue, Jul 29, 2014 at 03:56:19PM -0400, Alvaro Herrera wrote:
> > I have just pushed two optimization patches for multixacts to HEAD only.
> > I hesitate to backpatch them to 9.3 right away, but will consider doing
> > so if people think differently.
> > 
> > I also have a patch that supposedly fixes the performance regression
> > reported in bug #8470, but it's considerably more obscure so I'm not
> > pushing it right now.  It's attached.  I'd need to spend some more time
> > with it to ensure it doesn't break other cases before pushing.  I know
> > some people is interested in this fix and thought I'd throw it out there
> > to gather some input.
> > 
> > Since it affects much of the same code as the two patches I just pushed,
> > using it in 9.3 requires cherry-picking those patches, but they apply
> > without conflicts so it should be easy.
> 
> Wow, this is some very complex code.  Are you closer to a decision on it?

I am not, but I note that the input (such as benchmarks) I have received
on it  is nil -- which is surprising given that a number of people had
pinged me about this issue previously.

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



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: B-Tree support function number 3 (strxfrm() optimization)
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: pg_dump refactor patch to remove global variables