Re: Final Patch for GROUPING SETS - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Final Patch for GROUPING SETS
Date
Msg-id 61362087-28F3-49E5-873C-0DBCE58FD0B5@2ndquadrant.com
Whole thread Raw
In response to Re: Final Patch for GROUPING SETS  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
>I think the problem is "just" that for each variable, in each grouping
>set - a very large number in a large cube - we're recursing through the
>whole ChainAggregate tree, as each Var just points to a var one level
>lower.

For small values of very large, that is. Had a little thinko there. Its still fault of recursing down all these levels,
doingnontrivial work each time.
 

-- 
Please excuse brevity and formatting - I am writing this on my mobile phone.

Andres Freund                       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Final Patch for GROUPING SETS
Next
From: Amit Kapila
Date:
Subject: Re: Multi-xacts and our process problem