Re: slow vacuuming...

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: slow vacuuming...
Дата
Msg-id Pine.BSF.4.21.0011130829320.63528-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на slow vacuuming...  (David Powicki <dpowicki@oit.umass.edu>)
Ответы Re: slow vacuuming...
Список 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 по дате отправления:

Предыдущее
От: Marcin Mazurek
Дата:
Сообщение: dump and authentication
Следующее
От: "Hossein S. Zadeh"
Дата:
Сообщение: Re: slow vacuuming...