pgsql: Avoid running build_index_pathkeys() in situations where there - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Avoid running build_index_pathkeys() in situations where there
Date
Msg-id 20070415200928.E9B1E9FB1EF@postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Avoid running build_index_pathkeys() in situations where there cannot
possibly be any useful pathkeys --- to wit, queries with neither any
join clauses nor any ORDER BY request.  It's nearly free to check for
this case and it saves a useful fraction of the planning time for simple
queries.

Modified Files:
--------------
    pgsql/src/backend/optimizer/path:
        indxpath.c (r1.219 -> r1.220)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c.diff?r1=1.219&r2=1.220)
        pathkeys.c (r1.83 -> r1.84)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/pathkeys.c.diff?r1=1.83&r2=1.84)
    pgsql/src/include/optimizer:
        paths.h (r1.96 -> r1.97)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/paths.h.diff?r1=1.96&r2=1.97)

pgsql-committers by date:

Previous
From: adunstan@postgresql.org (Andrew Dunstan)
Date:
Subject: pgsql: Add --with-libxslt configure option
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Expose more cursor-related functionality in SPI: specifically,