Re: [GENERAL] Vacuum clarifications/issues - Mailing list pgsql-general

From The Hermit Hacker
Subject Re: [GENERAL] Vacuum clarifications/issues
Date
Msg-id Pine.BSF.4.21.9912171045260.4452-100000@thelab.hub.org
Whole thread Raw
In response to Vacuum clarifications/issues  ("Differentiated Software Solutions Pvt. Ltd." <diffs@vsnl.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Differentiated Software Solutions Pvt. Ltd."
Date:
Subject: Vacuum clarifications/issues
Next
From: Charles Alexander Randle
Date:
Subject: Re: SCO Openserver & pg_hba.conf