Re: Question about memory allocations

> 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