pgsql: Avoid considering both sort directions as equally useful for

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Avoid considering both sort directions as equally useful for
Date: 2007-10-27 05:45:43
Message-ID: 20071027054543.A0EC0754229@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Avoid considering both sort directions as equally useful for merging.
This doubles the planning workload for mergejoins while not actually
accomplishing much. The only useful case is where one of the directions
matches the query's ORDER BY request; therefore, put a thumb on the scales
in that direction, and otherwise arbitrarily consider only the ASC direction.
(This is a lot easier now than it would've been before 8.3, since we have
more semantic knowledge embedded in PathKeys now.)

Modified Files:
--------------
pgsql/src/backend/optimizer/path:
pathkeys.c (r1.85 -> r1.86)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/pathkeys.c?r1=1.85&r2=1.86)

Browse pgsql-committers by date

  From Date Subject
Next Message Simon Riggs 2007-10-27 09:24:29 Re: pgsql: Allow an autovacuum worker to be interrupted automatically when
Previous Message User Hinoue 2007-10-27 01:14:00 psqlodbc - psqlodbc: The version is now 8.2.0501.