Re: 8.2 is 30% better in pgbench than 8.3 - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: 8.2 is 30% better in pgbench than 8.3
Date
Msg-id 46A570BB.2010202@commandprompt.com
Whole thread Raw
In response to Re: 8.2 is 30% better in pgbench than 8.3  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
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/



pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: 8.2 is 30% better in pgbench than 8.3
Next
From: Tatsuo Ishii
Date:
Subject: avoiding WAL logging in 8.3