Vacuum clarifications/issues

From: "Differentiated Software Solutions Pvt(dot) Ltd(dot)" <diffs(at)vsnl(dot)com>
To: <pgsql-general(at)hub(dot)org>
Subject: Vacuum clarifications/issues
Date: 1999-12-17 14:11:42
Message-ID: 001801bf4899$7d8c3500$4bb5c5cb@nagma
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 1999-12-17 14:45:34 Re: [GENERAL] Vacuum clarifications/issues
Previous Message Karl Eichwalder 1999-12-17 13:34:44 Re: Installation problem on Suse linux 6.3