Re: Unexpectedly high disk space usage RESOLVED (Manual reindex/vacuum)

Поиск
Список
Период
Сортировка
От Greg Williamson
Тема Re: Unexpectedly high disk space usage RESOLVED (Manual reindex/vacuum)
Дата
Msg-id 1352515545.72495.YahooMailNeo@web125901.mail.ne1.yahoo.com
обсуждение исходный текст
Ответ на Re: Unexpectedly high disk space usage RESOLVED (Manual reindex/vacuum)  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Scott -- 

<...>

>To tune autovacuum with 50 databases, start by dropping nap time to
>something much lower, like 10s.  Then if you need to, drop cost delay
>until you get to 0.  If you get to 0 and it's still not hitting your
>IO too hard, but not keeping up, then increase cost limit.  If you get
>to something in the 5000 to 10000 range, and its still not keeping up
>then start bumping the thread count
>


Thanks for outlining a strategy on this -- useful advice.

Greg Williamson

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

Предыдущее
От: Chris Angelico
Дата:
Сообщение: PG defaults and performance (was Re: Unexpectedly high disk space usage RESOLVED (Manual reindex/vacuum))
Следующее
От: "Tefft, Michael J"
Дата:
Сообщение: "could not write to output file: Permission denied" during pg_dump