8.x Vaccum/Autovacuum settings

Поиск
Список
Период
Сортировка
От Chris Hoover
Тема 8.x Vaccum/Autovacuum settings
Дата
Msg-id 1d219a6f0606241503k3ae3e7d6lb1675fcb8b61bbc3@mail.gmail.com
обсуждение исходный текст
Ответы Re: 8.x Vaccum/Autovacuum settings
Re: 8.x Vaccum/Autovacuum settings
Список pgsql-admin
Just curious,

What are most of you setting your vacuum and autovacuum parameters to for your 8.x databases.  I just turned on autovacuuming on one of my db servers and went with a very conservative vacuum_cost_delay of 200 and vacuum_cost_limit of 50.  I am wondering if anyone else has tested to find out just how far you can push your vacuum/autovacuum before you start to feel performance hits from running it?

Thanks,

Chris

P.S. 

I chose these numbers based upon the documentation at http://www.powerpostgresql.com/Downloads/annotated_conf_80.html

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

Предыдущее
От: "hubert depesz lubaczewski"
Дата:
Сообщение: Re: Is it possible to trace all transactions done?
Следующее
От: "Dawid Kuroczko"
Дата:
Сообщение: Re: 8.x Vaccum/Autovacuum settings