| From: | tgl(at)postgresql(dot)org (Tom Lane) |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Avoid running build_index_pathkeys() in situations where there |
| Date: | 2007-04-15 20:09:28 |
| Message-ID: | 20070415200928.E9B1E9FB1EF@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-16 01:14:58 | pgsql: Expose more cursor-related functionality in SPI: specifically, |
| Previous Message | Andrew Dunstan | 2007-04-15 12:48:24 | pgsql: Add --with-libxslt configure option |