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 по дате отправления: