Re: Eternal vacuuming....

On Thu, 11 May 2000, Tim Perdue wrote:

> "Marc G. Fournier" wrote:
> > what does a 'vacuum verbose' show for you?  and youa ren't doing a 'vacuum
> > analyze', are you?
> 
> I believe I did 'vacuum analyze'. If info from 'vacuum verbose' would be
> useful to your team, I can try to set up and reproduce this. I would
> have to create a 3-million row table with an index on it, then delete
> 832,000 rows which I did last nite, then try again.

Okay, vacuum analyze is, from my experiences, atrociously slow ... it
*feels* faster, at least, if you do a simple vacuum first, then do the
analyze, but that might be just perception ...

Can you try just a simple 'vacuum verbose' first, without the analyze, and
see if that also takes 12hrs?

Also, what are you running this on?  Memory?  CPU?

Marc G. Fournier                               scrappy@hub.org
Systems Administrator @ hub.org                    
scrappy@{postgresql|isc}.org                       ICQ#7615664