On Tue, Sep 16, 2008 at 9:30 AM, kevin kempter <kevin@xxxxxxxxxxxxxxxxxxx> wrote: > Hi All; > > Is there an easy way to determine the actual OS disk cache size or at least > a set of guidelines based on the OS and disk subsystem type ? On a DB only machine, you can expect the OS to use most of the spare memory for disk cache eventually. So, if you've got a 16Gig machine and pgsql and the OS are using ~ 2 Gigs or so, the effective cache size will be what's left. OTOH, if the machine does other things (file / print server, web server, etc...) then you kinda have to fudge factor it. Generally pgsql will still use more disk cache than those other things, due to having more disk access going on all the time, but really it depends on your usage patterns. Luckily Effective cache size is a big course knob so being off by a gig or three isn't a really big deal.
