Re: upper planner path-ification - Mailing list pgsql-hackers

From Tom Lane
Subject Re: upper planner path-ification
Date
Msg-id 12179.1431958324@sss.pgh.pa.us
Whole thread Raw
In response to Re: upper planner path-ification  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: upper planner path-ification  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-hackers
Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> Incidentally, the most obvious obstacle to better planning of grouping
> sets in the sorted cases is not so much how to pick paths in
> grouping_planner itself, but rather the fact that query_planner wants to
> be given only one sort order. Is there any prospect for improvement
> there?

Hm.  That's a hangover from when query_planner also gave back a Plan
(singular) rather than a set of Paths.  I don't see any fundamental reason
why we couldn't generalize it to be a list of potentially useful output
orderings rather than just one.  But I'm a bit concerned about the ensuing
growth in planning time; is it really all that useful?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Bug in jsonb minus operator
Next
From: Uriy Zhuravlev
Date:
Subject: WIP: Enhanced ALTER OPERATOR