Thread: Vacuum clarifications/issues

Hi,

I'm vacuming a table containing 300,000 rows with a single index.
Currently it is taking 1.5 hours to complete. It was faster earlier.
I have dropped and recreated and reloaded this table. THis does not seem to
help.

Further... vacuum returns several messages.... like crashed... unused...
moved etc.,
Some of them have numbers.
Can anybody tell me what I should do with these and how to interpret them
etc.,

Thanks,

Murali

Differentiated Software Solutions Pvt. Ltd.,
176, Gr. Floor, 6th Main
2nd Block RT Nagar
Bangalore - 560 032
India
Ph: 91 80 3431470

On Fri, 17 Dec 1999, Differentiated Software Solutions Pvt. Ltd. wrote:

> Hi,
>
> I'm vacuming a table containing 300,000 rows with a single index.
> Currently it is taking 1.5 hours to complete. It was faster earlier.
> I have dropped and recreated and reloaded this table. THis does not seem to
> help.
>
> Further... vacuum returns several messages.... like crashed... unused...
> moved etc.,
> Some of them have numbers.
> Can anybody tell me what I should do with these and how to interpret them
> etc.,

Post them? :)

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org