Re: ever growing pkey files - Mailing list pgsql-admin

From Tom Lane
Subject Re: ever growing pkey files
Date
Msg-id 19453.997811911@sss.pgh.pa.us
Whole thread Raw
In response to ever growing pkey files  (matthew.copeland@honeywell.com)
Responses Re: ever growing pkey files  (matthew.copeland@honeywell.com)
List pgsql-admin
matthew.copeland@honeywell.com writes:
> 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?

Yeah, VACUUM doesn't shrink indexes presently (it's on the TODO
list...).

> PostgreSQL version 7.0.3 running under Linux.

You could try REINDEX to rebuild the indexes, but I'd recommend updating
to 7.1.2 (or soon, 7.1.3) first.  I don't recall whether REINDEX is
available/trustworthy in 7.0.

A grottier solution is to DROP and re-CREATE the indexes.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Crowe, Simon"
Date:
Subject: Postgress Unicode Support
Next
From: Allan Engelhardt
Date:
Subject: Re: Find a broken table