Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables

Поиск
Список
Период
Сортировка
От Paragon
Тема Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables
Дата
Msg-id 001201c89dbc$00de99e0$4c812e40@q
обсуждение исходный текст
Ответ на Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

> 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.

Thanks Tom, yap you were right now it runs instantaneously by resetting
vacuum back to defaults.  I feel kind of dumb at this point   :)
I guess misunderstood the docs.

Thanks again,
Regina




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

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