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

pgsql-server/ ontrib/pgstattuple/pgstattuple.c ...

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server/ ontrib/pgstattuple/pgstattuple.c ...
Date: 2004-05-08 19:09:25
Message-ID: 20040508190925.D4D7BD1E7F2@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
CVSROOT:	/cvsroot
Module name:	pgsql-server
Changes by:	tgl(at)svr1(dot)postgresql(dot)org	04/05/08 16:09:25

Modified files:
	contrib/pgstattuple: pgstattuple.c 
	src/backend/access/heap: heapam.c 
	src/backend/access/nbtree: nbtree.c 
	src/backend/catalog: heap.c index.c 
	src/backend/commands: analyze.c sequence.c vacuum.c vacuumlazy.c 
	src/backend/storage/buffer: bufmgr.c 
	src/backend/utils/cache: relcache.c 
	src/include/access: relscan.h 
	src/include/storage: bufmgr.h 
	src/include/utils: rel.h 

Log message:
	Get rid of rd_nblocks field in relcache entries.  Turns out this was
	costing us lots more to maintain than it was worth.  On shared tables
	it was of exactly zero benefit because we couldn't trust it to be
	up to date.  On temp tables it sometimes saved an lseek, but not often
	enough to be worth getting excited about.  And the real problem was that
	we forced an lseek on every relcache flush in order to update the field.
	So all in all it seems best to lose the complexity.


pgsql-committers by date

Next:From: Tom LaneDate: 2004-05-08 21:21:18
Subject: pgsql-server/src backend/nodes/outfuncs.c back ...
Previous:From: Fabien COELHODate: 2004-05-08 10:07:31
Subject: Re: Aclitem "high level description"

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