Re: slow vacuuming... - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: slow vacuuming...
Date
Msg-id Pine.BSF.4.21.0011130829320.63528-100000@megazone23.bigpanda.com
Whole thread Raw
In response to slow vacuuming...  (David Powicki <dpowicki@oit.umass.edu>)
Responses Re: slow vacuuming...  ("Hossein S. Zadeh" <hossein@hossein.bf.rmit.edu.au>)
List pgsql-admin
That does seem like a long time...  If you have any indexes (I don't
remember if \d in 6.5 showed those) you might want to try dropping them,
doing the vacuum and recreating them and see if that's any faster.

Stephan Szabo
sszabo@bigpanda.com

On Mon, 13 Nov 2000, David Powicki wrote:

> Each day the DB grows to ~70MB in size and takes upwards of 25 minutes to
> vacuum.  A 70MB DB doesn't sound too big and 25 minutes is a painfully long time
> to wait.
>
> Any ideas?


pgsql-admin by date:

Previous
From: Marcin Mazurek
Date:
Subject: dump and authentication
Next
From: "Hossein S. Zadeh"
Date:
Subject: Re: slow vacuuming...