Re: Some Autovacuum Questions

Поиск
Список
Период
Сортировка
От Decibel!
Тема Re: Some Autovacuum Questions
Дата
Msg-id F59A5379-C678-4454-858B-CAD81682EB9E@decibel.org
обсуждение исходный текст
Ответ на Some Autovacuum Questions  ("Thomas Chille" <thomas@chille.de>)
Список pgsql-general
On Feb 12, 2008, at 9:13 AM, Thomas Chille wrote:
> vacuum_cost_delay = 200
> vacuum_cost_page_hit = 6
> vacuum_cost_limit = 100


Vacuum is going to take forever with those settings. I strongly
suggest you set them back to default. If you need to throttle vacuum,
try setting cost_delay to between 10 and 20.
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



Вложения

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

Предыдущее
От: "Dan Armbrust"
Дата:
Сообщение: performance issues on windows with 8.3.0?
Следующее
От: "Emil J."
Дата:
Сообщение: pg_dump, pg_restore.