pgsql: Department of second thoughts: the rule that ORDER BY and

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Department of second thoughts: the rule that ORDER BY and
Date: 2008-03-28 02:00:11
Message-ID: 20080328020011.DB8847558E7@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Department of second thoughts: the rule that ORDER BY and DISTINCT are
useless for an ungrouped-aggregate query holds regardless of whether
optimize_minmax_aggregates succeeds. So we might as well apply the
optimization in any case.

I'll leave 8.3 as it was, since this version is a tad more invasive
than my earlier patch.

Modified Files:
--------------
pgsql/src/backend/optimizer/plan:
planner.c (r1.228 -> r1.229)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planner.c?r1=1.228&r2=1.229)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2008-03-28 02:36:04 pgsql: Add: > * Allow one transaction to see tuples using the snapshot
Previous Message Tom Lane 2008-03-28 00:21:56 pgsql: Support statement-level ON TRUNCATE triggers.