Re: Shared memory usage

Поиск
Список
Период
Сортировка
От Max Zorloff
Тема Re: Shared memory usage
Дата
Msg-id op.txmzk9j1ll0p5y@1-rtt202dnf3uds.mshome.net
обсуждение исходный текст
Ответ на Re: Shared memory usage  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
On Sun, 26 Aug 2007 00:39:52 +0400, Martijn van Oosterhout
<kleptog@svana.org> wrote:

> On Sun, Aug 26, 2007 at 01:22:58AM +0400, Max Zorloff wrote:
>> Hello.
>>
> shared_memory is used for caching. It is filled as stuff is used. If
> you're not using all of it that means it isn't needed. Remember, it is
> not the only cache. Since your database is only 400MB it will fit
> entirely inside the OS disk cache, so you really don't need much shared
> memory at all.
>
> Loading stuff into memory for the hell of it is a waste, let the system
> manage the memory itself, if it needs it, it'll use it.
>

Where do I find my OS disk cache settings? I'm using Linux.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Max Zorloff"
Дата:
Сообщение: Re: Shared memory usage
Следующее
От: Kevin Kempter
Дата:
Сообщение: SQL Diff ?