Re: Disk Utilization Increases And Time for Vacuum Increases.

On Wed, 27 Aug 2003, Tom Lane wrote:

> Curt Sampson <cjs@cynic.net> writes:
> > While we're at it, anybody got a clue on how to reindex system tables?
> The procedure given in the REINDEX reference page doesn't work for you?

You mean with the standalone backend? All the other developers get
pissed at me when I take down the database cluster. :-) Heck, I get
pissed at me because some other thing I was running in the background
goes and blows up.

I'm not actually sure why there would be a problem (aside from
performance) in removing and rebuilding an index on a system table,
unless there are cached query plans somewhere that would try to use
the old or now-nonexistent index.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.NetBSD.org
    Don't you know, in this new Dark Age, we're all light.  --XTC