Re: plan time of MASSIVE partitioning ... - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: plan time of MASSIVE partitioning ...
Date
Msg-id 1283960300-sup-4372@alvh.no-ip.org
Whole thread Raw
In response to Re: plan time of MASSIVE partitioning ...  (Stephen Frost <sfrost@snowman.net>)
Responses Re: plan time of MASSIVE partitioning ...
List pgsql-hackers
Excerpts from Stephen Frost's message of mié sep 08 11:26:55 -0400 2010:
> * Hans-Jürgen Schönig (postgres@cybertec.at) wrote:
> > but, it seems the problem we are looking is not sufficiently fixed yet.
> > in our case we shaved off some 18% of planning time or so - looking at the other top 2 functions i got the feeling
thatmore can be done to reduce this. i guess we have to attack this as well.
 
> 
> An 18% increase is certainly nice, provided it doesn't slow down or
> break other things..  I'm looking through the patch now actually and
> I'm not really happy with the naming, comments, or some of the code
> flow, but I think the concept looks reasonable.

I don't understand the layering between pg_tree and rbtree.  Why does it
exist at all?  At first I thought this was another implementation of
rbtrees, but then I noticed it sits on top of it.  Is this really
necessary?

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: plan time of MASSIVE partitioning ...
Next
From: Tom Lane
Date:
Subject: Re: plan time of MASSIVE partitioning ...