pgsql: Avoid considering both sort directions as equally useful for

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Avoid considering both sort directions as equally useful for
Дата
Msg-id 20071027054543.A0EC0754229@cvs.postgresql.org
обсуждение исходный текст
Список 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)

В списке pgsql-committers по дате отправления:

Предыдущее
От: hinoue@pgfoundry.org (User Hinoue)
Дата:
Сообщение: psqlodbc - psqlodbc: The version is now 8.2.0501.
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: pgsql: Allow an autovacuum worker to be interrupted automatically when