Re: slow vacuuming...

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: David Powicki <dpowicki(at)oit(dot)umass(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: slow vacuuming...
Date: 2000-11-13 16:31:23
Message-ID: Pine.BSF.4.21.0011130829320.63528-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)bigpanda(dot)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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Hossein S. Zadeh 2000-11-14 01:07:16 Re: slow vacuuming...
Previous Message Marcin Mazurek 2000-11-13 16:21:50 dump and authentication