pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSetting Effective Cache Size
2+ messages / 2 participants
[nested] [flat]
* Setting Effective Cache Size
@ 2008-09-16 15:30 kevin kempter <kevin@kevinkempterllc.com>
0 siblings, 1 reply; 2+ messages in thread
From: kevin kempter @ 2008-09-16 15:30 UTC (permalink / raw)
To: pgsql-admin
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 ?
Thanks in advance...
/Kevin
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Setting Effective Cache Size
@ 2008-09-16 18:50 Scott Marlowe <scott.marlowe@gmail.com>
parent: kevin kempter <kevin@kevinkempterllc.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2008-09-16 18:50 UTC (permalink / raw)
To: kevin kempter <kevin@kevinkempterllc.com>; +Cc: pgsql-admin
On Tue, Sep 16, 2008 at 9:30 AM, kevin kempter
<kevin@kevinkempterllc.com> 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-09-16 18:50 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-16 15:30 Setting Effective Cache Size kevin kempter <kevin@kevinkempterllc.com>
2008-09-16 18:50 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox