Re: Shared memory usage - Mailing list pgsql-general

From Max Zorloff
Subject Re: Shared memory usage
Date
Msg-id op.txmzk9j1ll0p5y@1-rtt202dnf3uds.mshome.net
Whole thread Raw
In response to Re: Shared memory usage  (Martijn van Oosterhout <kleptog@svana.org>)
List 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 by date:

Previous
From: "Max Zorloff"
Date:
Subject: Re: Shared memory usage
Next
From: Kevin Kempter
Date:
Subject: SQL Diff ?