JD,

> Don't get me wrong, I want things to be easily understandable as well
> but the reason you site above pretty much
> makes us need to remove most of the postgresql.conf, including all
> bgwriter, vacuum cost delay, and autovac settings.
> Not to mention commit delay and others ;).

Wouldn't that be nice!

The explosion of GUC settings is primarily a result of not enough information.  
The reason there are 7 bgwriter settings, for example, is that we have no 
idea what those settings should be and are hoping that people will tinker 
with them and tell us.  Someday when I can fully profile bgwriter, we'll just 
have one setting: bgwriter_aggressive, set to a number between 0 and 9.  

-- 
Josh Berkus
PostgreSQL @ Sun
San Francisco

---------------------------(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