pgsql/src/backend/catalog (index.c)

Date: Saturday, June 17, 2000 @ 17:48:40
Author: tgl

Update of /home/projects/pgsql/cvsroot/pgsql/src/backend/catalog
from hub.org:/home/projects/pgsql/tmp/cvs-serv55574/backend/catalog

Modified Files:
index.c

----------------------------- Log Message -----------------------------

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.