Re: basic question (shared buffers vs. effective cache - Mailing list pgsql-general

From scott.marlowe
Subject Re: basic question (shared buffers vs. effective cache
Date
Msg-id Pine.LNX.4.33.0405101354520.16845-100000@css120.ihs.com
Whole thread Raw
In response to Re: basic question (shared buffers vs. effective cache size)  ("Sally Sally" <dedeb17@hotmail.com>)
List 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.


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: basic question (shared buffers vs. effective cache
Next
From: Rory Campbell-Lange
Date:
Subject: Re: Very slow query