Re: basic question (shared buffers vs. effective cache

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: basic question (shared buffers vs. effective cache
Дата
Msg-id Pine.LNX.4.33.0405101354520.16845-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: basic question (shared buffers vs. effective cache size)  ("Sally Sally" <dedeb17@hotmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: basic question (shared buffers vs. effective cache
Следующее
От: Rory Campbell-Lange
Дата:
Сообщение: Re: Very slow query