From d03a933ec5400f77fc132d4a47bb7d2981ff5187 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 17 Jun 2000 21:49:04 +0000 Subject: Fix performance problems with pg_index lookups (see, for example, discussion of 5/19/00). pg_index is now searched for indexes of a relation using an indexscan. Moreover, this is done once and cached in the relcache entry for the relation, in the form of a list of OIDs for the indexes. This list is used by the parser and executor to drive lookups in the pg_index syscache when they want to know the properties of the indexes. Net result: index information will be fully cached for repetitive operations such as inserts. --- src/backend/executor/nodeAppend.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/backend/executor/nodeAppend.c') diff --git a/src/backend/executor/nodeAppend.c b/src/backend/executor/nodeAppend.c index 51e7d4027e6..5e34e806e32 100644 --- a/src/backend/executor/nodeAppend.c +++ b/src/backend/executor/nodeAppend.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/executor/nodeAppend.c,v 1.33 2000/06/15 04:09:52 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/executor/nodeAppend.c,v 1.34 2000/06/17 21:48:49 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -285,7 +285,7 @@ ExecInitAppend(Append *node, EState *estate, Plan *parent) * indices, but how to tell that here? */ if (rri->ri_RelationDesc->rd_rel->relhasindex) - ExecOpenIndices(reloid, rri); + ExecOpenIndices(rri); } /* -- cgit v1.2.3