Re: plan time of MASSIVE partitioning ...

Boszormenyi Zoltan írta:
> Heikki Linnakangas írta:
>   
>> On 26.10.2010 18:34, Boszormenyi Zoltan wrote:
>>     
>>> thank you very much for pointing me to dynahash, here is the
>>> next version that finally seems to work.
>>>
>>> Two patches are attached, the first is the absolute minimum for
>>> making it work, this still has the Tree type for canon_pathkeys
>>> and eq_classes got the same treatment as join_rel_list/join_rel_hash
>>> has in the current sources: if the list grows larger than 32, a hash
>>> table
>>> is created. It seems to be be enough for doing in for
>>>       get_eclass_for_sort_expr()
>>> only, the other users of eq_classes aren't bothered by this change.
>>>       
>> That's better, but can't you use dynahash for canon_pathkeys as well?
>>     
>
> Here's a purely dynahash solution. It's somewhat slower than
> the tree version, 0.45 vs 0.41 seconds in the cached case for the
> previously posted test case.
>   

And now in context diff, sorry for my affection towards unified diffs. :-)

> Best regards,
> Zoltán Böszörményi
>
>   


-- 
----------------------------------
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/