Re: Table Vacuum Taking a Long Time

Поиск
Список
Период
Сортировка
От Hannes Erven
Тема Re: Table Vacuum Taking a Long Time
Дата
Msg-id 533C30D8.5040704@erven.at
обсуждение исходный текст
Ответ на Table Vacuum Taking a Long Time  (Eliot Gable <egable+pgsql-general@gmail.com>)
Список pgsql-general
Hi Eliot,


 > If I continue to run vacuum
 > analyze on it, it continues to take about 90 seconds each time.
 > [..]
 > I was under the impression that if nothing had been done to the table
 > since it was last vacuumed, that it would return immediately.

in addition to what others already said, I'd expect that by specifying
ANALYZE you are forcing PostgreSQL to do quite expensive additional work.

Is there a reason why you cannot (or do not want to) rely on
autovaccuum? Have you tried tuning the parameters?

Even if you must use manual VACUUMs, you can probably get away without
ANALZE.


Best regards,

    -hannes


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Lock problem
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Lock problem