Re: [PATCHES] reorder GROUP BY list

2006-03-05 Thread Neil Conway
On Sun, 2006-03-05 at 00:04 -0500, Neil Conway wrote: Okay, attached is a revised patch that implements this. Applied. -Neil ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index

[PATCHES] reorder GROUP BY list

2006-03-04 Thread Neil Conway
Per recent discussion on -hackers, we should sometimes try to reorder the columns of the grouping clause to avoid redundant sorts. The optimizer is not currently capable of doing this, so this patch implements a simple hack in the analysis phase (transformGroupClause): if any subset of the GROUP

Re: [PATCHES] reorder GROUP BY list

2006-03-04 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: Per recent discussion on -hackers, we should sometimes try to reorder the columns of the grouping clause to avoid redundant sorts. The optimizer is not currently capable of doing this, so this patch implements a simple hack in the analysis phase