| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | "Differentiated Software Solutions Pvt(dot) Ltd(dot)" <diffs(at)vsnl(dot)com> |
| Cc: | pgsql-general(at)hub(dot)org |
| Subject: | Re: [GENERAL] Vacuum clarifications/issues |
| Date: | 1999-12-17 14:45:34 |
| Message-ID: | Pine.BSF.4.21.9912171045260.4452-100000@thelab.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charles Alexander Randle | 1999-12-17 15:00:13 | Re: SCO Openserver & pg_hba.conf |
| Previous Message | Differentiated Software Solutions Pvt. Ltd. | 1999-12-17 14:11:42 | Vacuum clarifications/issues |