Thread

1. Re: basic question (shared buffers vs. effective cache size)

   Sally Sally <dedeb17@hotmail.com> — 2004-05-10T18:12:13Z

   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).
   Thanks
   Sally
   
   _________________________________________________________________
   Stop worrying about overloading your inbox - get MSN Hotmail Extra Storage! 
   http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm00200362ave/direct/01/
   
   
   

2. Re: basic question (shared buffers vs. effective cache

   scott.marlowe <scott.marlowe@ihs.com> — 2004-05-10T19:55:49Z

   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.