Postgres Pro
Downloads
Home   >   mailing lists

pgsql/src/backend/commands (copy.c indexcmds.c vacuum.c) - Mailing list pgsql-committers

From Tom Lane
Subject pgsql/src/backend/commands (copy.c indexcmds.c vacuum.c)
Date
Msg-id 200006172148.e5HLmkd55700@hub.org
Whole thread Raw
List pgsql-committers
Tree view 
  Date: Saturday, June 17, 2000 @ 17:48:45
Author: tgl

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

Modified Files:
    copy.c indexcmds.c vacuum.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.

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql/src/backend/parser (analyze.c)
Next
From: Tom Lane
Date:
Subject: pgsql/src/backend/executor (execMain.c execUtils.c nodeAppend.c)