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/