Skip site navigation (1) Skip section navigation (2)

pgsql/src backend/access/index/genam.c backend ...

From: tgl(at)postgresql(dot)org
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql/src backend/access/index/genam.c backend ...
Date: 2002-02-19 20:11:22
Message-ID: 200202192011.g1JKBMK91946@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
CVSROOT:	/cvsroot
Module name:	pgsql
Changes by:	tgl(at)postgresql(dot)org	02/02/19 15:11:20

Modified files:
	src/backend/access/index: genam.c istrat.c 
	src/backend/catalog: heap.c index.c indexing.c 
	src/backend/commands: cluster.c command.c trigger.c vacuum.c 
	src/backend/executor: execAmi.c execUtils.c nodeIndexscan.c 
	                      nodeSeqscan.c nodeTidscan.c 
	src/backend/optimizer/util: plancat.c 
	src/backend/parser: parse_func.c parse_oper.c 
	src/backend/utils/adt: ruleutils.c 
	src/backend/utils/cache: catcache.c inval.c relcache.c 
	                         syscache.c 
	src/backend/utils/init: postinit.c 
	src/include/access: genam.h istrat.h 
	src/include/catalog: index.h indexing.h 
	src/include/executor: executor.h 
	src/include/storage: lwlock.h 
	src/include/utils: catcache.h rel.h relcache.h syscache.h 

Log message:
	A bunch of changes aimed at reducing backend startup time...
	
	Improve 'pg_internal.init' relcache entry preload mechanism so that it is
	safe to use for all system catalogs, and arrange to preload a realistic
	set of system-catalog entries instead of only the three nailed-in-cache
	indexes that were formerly loaded this way.  Fix mechanism for deleting
	out-of-date pg_internal.init files: this must be synchronized with transaction
	commit, not just done at random times within transactions.  Drive it off
	relcache invalidation mechanism so that no special-case tests are needed.
	
	Cache additional information in relcache entries for indexes (their pg_index
	tuples and index-operator OIDs) to eliminate repeated lookups.  Also cache
	index opclass info at the per-opclass level to avoid repeated lookups during
	relcache load.
	
	Generalize 'systable scan' utilities originally developed by Hiroshi,
	move them into genam.c, use in a number of places where there was formerly
	ugly code for choosing either heap or index scan.  In particular this allows
	simplification of the logic that prevents infinite recursion between syscache
	and relcache during startup: we can easily switch to heapscans in relcache.c
	when and where needed to avoid recursion, so IndexScanOK becomes simpler and
	does not need any expensive initialization.
	
	Eliminate useless opening of a heapscan data structure while doing an indexscan
	(this saves an mdnblocks call and thus at least one kernel call).


pgsql-committers by date

Next:From: momjianDate: 2002-02-19 20:31:32
Subject: pgsql/doc TODO
Previous:From: tglDate: 2002-02-19 19:54:43
Subject: pgsql/src/backend/tcop postgres.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group