Re: basic question (shared buffers vs. effective cache

scott.marlowe <scott.marlowe@ihs.com>

From: "scott.marlowe" <scott.marlowe@ihs.com>
To: Sally Sally <dedeb17@hotmail.com>
Cc: <pgsql-general@postgresql.org>
Date: 2004-05-10T19:55:49Z
Lists: pgsql-general
On Mon, 10 May 2004, Sally Sally wrote:

> Thanks much Scott, makes sense now.
> 
> You said
> 
> "Now, effective_cache_size sets nothing other than itself.  I.e. it
> allocates nothing in memory.  It is pretty much a big course setting knob
> that tells the planner about how much memory the kernel is using to cache
> its data"
> 
> So how can you know how much memory the kernel is actually using to cache 
> (Solaris)? and specifically is it something you can set/change and also 
> watch as it is happening with some command like top (Linux shows how much is 
> cached but I don't see that in Solaris).

I'm not sure.  I think vmstat can tell you that.