pgsql: Install a lookaside cache to speed up repeated lookups of the

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Install a lookaside cache to speed up repeated lookups of the
Date: 2007-11-28 18:47:56
Message-ID: 20071128184756.CC0CF7540F0@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
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.

Modified Files:
--------------
pgsql/src/backend/catalog:
namespace.c (r1.102 -> r1.103)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/namespace.c?r1=1.102&r2=1.103)
pgsql/src/backend/parser:
parse_oper.c (r1.98 -> r1.99)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/parse_oper.c?r1=1.98&r2=1.99)
pgsql/src/include/catalog:
namespace.h (r1.51 -> r1.52)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/namespace.h?r1=1.51&r2=1.52)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2007-11-28 19:33:05 pgsql: Adjust the names of a couple of tsearch index support functions
Previous Message David Fetter 2007-11-28 16:44:03 dbi-link - dbi-link: Changed README.Oracle and