Fix out-dated comment in preprocess_groupclause()

david-rowley · david-rowley · commit f6c70b81802a · 2022-09-20T09:15:04.000+12:00
The comment claimed we don't consider other orders of the GROUP BY clause, but this is no longer true as of db0d67d. Discussion: https://postgr.es/m/CAApHDvq65=9Ro+hLX1i9ugWEiNDvHrBibAO7ARcTnf38_JE+UQ@mail.gmail.com Backpatch-through: 15, where db0d67d was introduced.
diff --git a/src/backend/optimizer/plan/planner.c b/src/backend/optimizer/plan/planner.c
@@ -2756,8 +2756,9 @@ remove_useless_groupby_columns(PlannerInfo *root)
  *
  * In principle it might be interesting to consider other orderings of the
  * GROUP BY elements, which could match the sort ordering of other
- * possible plans (eg an indexscan) and thereby reduce cost.  We don't
- * bother with that, though.  Hashed grouping will frequently win anyway.
+ * possible plans (eg an indexscan) and thereby reduce cost.  However, we
+ * don't yet have sufficient information to do that here, so that's left until
+ * later in planning.  See get_useful_group_keys_orderings().
  *
  * Note: we need no comparable processing of the distinctClause because
  * the parser already enforced that that matches ORDER BY.

Original file line number	Diff line number	Diff line change
`@@ -2756,8 +2756,9 @@ remove_useless_groupby_columns(PlannerInfo *root)`
`2756`	`2756`	`*`
`2757`	`2757`	`* In principle it might be interesting to consider other orderings of the`
`2758`	`2758`	`* GROUP BY elements, which could match the sort ordering of other`
`2759`		`- * possible plans (eg an indexscan) and thereby reduce cost. We don't`
`2760`		`- * bother with that, though. Hashed grouping will frequently win anyway.`
	`2759`	`+ * possible plans (eg an indexscan) and thereby reduce cost. However, we`
	`2760`	`+ * don't yet have sufficient information to do that here, so that's left until`
	`2761`	`+ * later in planning. See get_useful_group_keys_orderings().`
`2761`	`2762`	`*`
`2762`	`2763`	`* Note: we need no comparable processing of the distinctClause because`
`2763`	`2764`	`* the parser already enforced that that matches ORDER BY.`