Re: "Vacuum Full Analyze" taking so long

Поиск
Список
Период
Сортировка
От Michael Stone
Тема Re: "Vacuum Full Analyze" taking so long
Дата
Msg-id 20050725213058.GQ19080@mathom.us
обсуждение исходный текст
Ответ на "Vacuum Full Analyze" taking so long  ("Tomeh, Husam" <htomeh@firstam.com>)
Список pgsql-performance
I'd say, "don't do that". Unless you've deleted a lot of stuff and are
expecting the DB to shrink, a full vacuum shouldn't really be needed. On
a DB that big a full vacuum is just going to take a long time. If you
really are shrinking, consider structuring things so you can just drop a
table instead of vacuuming it (the drop is fairly instantaneous). If you
can't do that, consider dropping the indices, vacuuming, and recreating
the indices.

Mike Stone

В списке pgsql-performance по дате отправления:

Предыдущее
От: John A Meinel
Дата:
Сообщение: Re: COPY insert performance
Следующее
От: "Luke Lonergan"
Дата:
Сообщение: Re: "Vacuum Full Analyze" taking so long