Re: plan time of MASSIVE partitioning ...

Tom Lane írta:
> Boszormenyi Zoltan <zb@cybertec.at> writes:
>   
>> This applies to anything else that may need to be converted
>> from list to tree to decrease planning time. Like ec_members
>> in EquivalenceClass.
>>     
>
> AFAIR, canonical pathkeys are the *only* thing in the planner where pure
> pointer equality is interesting.  So I doubt this hack is of any use for
> EquivalenceClass, even if the lists were likely to be long which they
> aren't.
>
> 			regards, tom lane
>   

No, for EquivalanceClass->ec_member, I need to do something
funnier, like implement compare(Node *, Node *) and use that
instead of equal(Node *, Node *)... Something like nodeToString()
on both Node * and strcmp() the resulting strings.

-- 
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
     http://www.postgresql.at/