Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Department of second thoughts: the rule that ORDER BY and - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Department of second thoughts: the rule that ORDER BY and
Date
Msg-id 20080328020011.DB8847558E7@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Support statement-level ON TRUNCATE triggers.
Next
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Add: > * Allow one transaction to see tuples using the snapshot