Robert Haas wrote: > On Mon, Apr 19, 2010 at 5:36 PM, Bruce Momjian <br...@momjian.us> wrote: > >> I don't actually know what's best. ?I'm just concerned that we have a > >> default in postgresql.conf and a tuning guide that says "don't do > >> that". ?Maybe the tuning guide needs to be more nuanced, or maybe > >> postgresql.conf needs to be changed, but it makes no sense to have > >> them saying contradictory things. > > > > The good news about checkpoint_segments is that you get a log file > > warning message if the value should be increased, i.e. you are > > checkpointing often than 30 seconds. > > Yeah. I get that warning frequently when I'm creating test tables of > dummy data for PG devel purposes. That's actually the main thing that > makes me think the default may be too low.
Well, the point is that you are getting it for _unusual_ circumstances. Seems it is only when you are getting it for typical workloads that it should be increased. However, this is the first time I am hearing that battery-backed cache favors the default value. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
