From: Scott Marlowe <scott.marlowe@gmail.com>
To: dx k9 <bitsandbytes88@hotmail.com>
Cc: posgres support <pgsql-admin@postgresql.org>
Subject: Re: cached memory
Date: Wed, 14 Nov 2007 15:20:53 -0600
Message-ID: <dcc563d10711141320u68b2a5e8madc18f915cb1b27a@mail.gmail.com> (raw)
In-Reply-To: <BAY116-W299DD053ED5A22FA305F15D1810@phx.gbl>
References: <BAY116-W299DD053ED5A22FA305F15D1810@phx.gbl>
On Nov 14, 2007 3:13 PM, dx k9 <bitsandbytes88@hotmail.com> wrote:
>
> In looking at some cacti memory usage graphs, the Oracle servers show
> only 6 of a total of16 GB of RAM as 'Total Available'. Whereas, our
> Postgres version 8.24 servers show all 16 GB of RAM totally available or
> free. Some people are asking why Postgres doesn't take that memory and
> lock into it, so you can't see less 'total available' memory. We use a lot
> of B-tree indexes. This may or may not be related, but it there a good way
> to make sure those stay in memory?
Not sure what you mean by totally available. Is the OS using it to
cache? If so, why should postgresql do what the OS already does so
well.
Oracle was written back when OSes were barely more than program
loaders and it had to do everything, from having its own file systems
to buffering / caching to memory management to job schedulers.
PostgreSQL was written as Unix was maturing (mostly) and takes
advantage of all the cool things a modern unix comes with, and one of
those things is kernel level caching of disk files.
So, what does free / top have to say about your memory? And how hard
have these servers been working. For instance, my RHEL4 reporting
server, with only 2 Gigs in it shows 1868064 used as kernel cache.
The rest is mostly pgsql processes
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, bitsandbytes88@hotmail.com
Subject: Re: cached memory
In-Reply-To: <dcc563d10711141320u68b2a5e8madc18f915cb1b27a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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