Re: 8.2 is 30% better in pgbench than 8.3 - Mailing list 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