Re: 8.2 is 30% better in pgbench than 8.3

Gregory Stark wrote:
> "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%.

I think that 5-10% is reasonable, 20% is way to high.

Joshua D. Drake



-- 
      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/