diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2007-11-28 18:47:56 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2007-11-28 18:47:56 +0000 |
| commit | d54ca56743d5b0bb43f7cd951290384a6933e9f9 (patch) | |
| tree | 8133128188b9f28e4ac5f833c3a5f9f965e4d117 /src/include | |
| parent | a238bd146d696bf8c034a0c3a3197f37f111addc (diff) | |
| download | postgresql-d54ca56743d5b0bb43f7cd951290384a6933e9f9.tar.gz | |
Install a lookaside cache to speed up repeated lookups of the same operator
by short-circuiting schema search path and ambiguous-operator resolution
computations. Remarkably, this buys as much as 45% speedup of repetitive
simple queries that involve operators that are not an exact match to the
input datatypes. It should be marginally faster even for exact-match
cases, though I've not had success in proving an improvement in benchmark
tests. Per report from Guillame Smet and subsequent discussion.
Diffstat (limited to 'src/include')
| -rw-r--r-- | src/include/catalog/namespace.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/include/catalog/namespace.h b/src/include/catalog/namespace.h index c2c3f7512a..c2ad9d36c3 100644 --- a/src/include/catalog/namespace.h +++ b/src/include/catalog/namespace.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $PostgreSQL: pgsql/src/include/catalog/namespace.h,v 1.51 2007/11/15 22:25:17 momjian Exp $ + * $PostgreSQL: pgsql/src/include/catalog/namespace.h,v 1.52 2007/11/28 18:47:56 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -115,5 +115,6 @@ extern void AtEOSubXact_Namespace(bool isCommit, SubTransactionId mySubid, extern char *namespace_search_path; extern List *fetch_search_path(bool includeImplicit); +extern int fetch_search_path_array(Oid *sarray, int sarray_len); #endif /* NAMESPACE_H */ |