I didn't notice anyone address this for you yet. There is a tool in
contrib/pg_buffercache whose purpose in life is to show you what the shared
buffer cache has inside it. The documentation in that directory leads
through installing it. The additional variable you'll likely never know is
what additional information is inside the operating system's buffer cache.
Okay -- thanks! I'll take a look at this.
# Leaving this low makes the DB complain, but I'm not sure what's #
reasonable.
checkpoint_segments = 128
That's a reasonable setting for a large server. The main downside to setting
it that high is longer recovery periods after a crash, but I doubt that's a
problem for you if you're so brazen as to turn off fsync.
Hahaha yeah. It's 100% assumed that if something goes bad we're
restoring from the previous day's backup. However because the DB is read
only for -most- of the day and only read/write at night it's acceptable
risk for us anyway. But good to know that's a reasonable value.
Steve
