Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables
Дата
Msg-id 24994.1208128127@sss.pgh.pa.us
обсуждение исходный текст
Ответ на VACUUM hanging on PostgreSQL 8.3.1 for larger tables  ("Paragon" <lr@pcorp.us>)
Ответы Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables  ("Paragon" <lr@pcorp.us>)
Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables  (Dragan Zubac <zubac@vlayko.tv>)
Список pgsql-general
"Paragon" <lr@pcorp.us> writes:
> Right now I have
> vacuum_cost_delay = 600

Yikes.  That's *way* too high.  If you're trying to get the vacuum to
complete quickly, it really should be zero anyway.  Nonzero is for when
you don't care how long vacuum takes as long as it's not sucking too much
I/O from your real work.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables
Следующее
От: Ted Byers
Дата:
Сообщение: Re: No Return??