> Sorry. I wrote PG 7.4.2 and then I erased it to write something else and
> then forgot to add it back.
Odd. You shouldn't be having to re-vacuum on 7.4.
> And thanks for the Page info. I was getting frustrated and looked in the
> wrong place.
> So it's probably best to drop and readd the indexes then?
Well, I have to wonder if you've not run afoul of the known 7.4.2 bug
regarding indexes. This system hasn't had an improper database shutdown or
power-out in the last few weeks, has it?
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Gaetano Mendola||Date: 2004-09-21 22:52:06|
|Subject: 7.4 vs 7.3 ( hash join issue )|
|Previous:||From: Patrick Hatcher||Date: 2004-09-21 17:45:37|
|Subject: Re: vacuum full & max_fsm_pages question|