ever growing pkey files - Mailing list pgsql-admin

From matthew.copeland@honeywell.com
Subject ever growing pkey files
Date
Msg-id Pine.LNX.4.21.0108141433300.1141-100000@fisb.gaa.aro.allied.com
Whole thread Raw
In response to Find a broken table  (Ariunbold Gerelt-Od <gereltod@kikakuya.com>)
Responses Re: ever growing pkey files  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
I have a database that has two tables.  One of the tables gets changed
very often.  (like every 5 minutes).  The values that where in the table
are replaced with a new set of values with new unique keys.  Now, I vacuum
these tables fairly often, but the pkey files for these tables never seem
to get smaller.  They just keep growing.  What do I have to do to make the
pkey files flush there extra blocks?

PostgreSQL version 7.0.3 running under Linux.

Matthew M. Copeland




pgsql-admin by date:

Previous
From: Alan Gutierrez
Date:
Subject: Re: upgrading RPM query
Next
From: silas@spamcop.net (Chris Hardie)
Date:
Subject: SNMP MIB for PostgreSQL?