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.