"Alvaro Herrera" <[EMAIL PROTECTED]> writes:

>> Alvaro Herrera <[EMAIL PROTECTED]> 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


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

Reply via email to