Re: 8.2 is 30% better in pgbench than 8.3

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: 8.2 is 30% better in pgbench than 8.3
Дата
Msg-id 87fy3er01y.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: 8.2 is 30% better in pgbench than 8.3  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: 8.2 is 30% better in pgbench than 8.3
autovacuum default parameters (was Re: 8.2 is 30% better in pgbench than 8.3)
Список pgsql-hackers
"Alvaro Herrera" <alvherre@commandprompt.com> writes:

>> Alvaro Herrera <alvherre@commandprompt.com> writes:
>> >
>> > I am taking the liberty to also lower the vacuum and analyze threshold
>> > default values to 50, per previous discussion.

Did we also reach any consensus about lowering the percentage of dead tuples
in a table before we trigger vacuum? I think 20% is way too high and 5% is
saner. I actually think it would be better even lower but would be ok with 5%.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: 8.2 is 30% better in pgbench than 8.3
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: 8.2 is 30% better in pgbench than 8.3