| From: | "Max Zorloff" <zorloff(at)gmail(dot)com> |
|---|---|
| To: | "Martijn van Oosterhout" <kleptog(at)svana(dot)org> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Shared memory usage |
| Date: | 2007-08-25 22:32:59 |
| Message-ID: | op.txmzk9j1ll0p5y@1-rtt202dnf3uds.mshome.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On Sun, 26 Aug 2007 00:39:52 +0400, Martijn van Oosterhout
<kleptog(at)svana(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Kempter | 2007-08-26 02:51:59 | SQL Diff ? |
| Previous Message | Max Zorloff | 2007-08-25 22:22:23 | Re: Shared memory usage |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Tauno Williams | 2007-08-27 10:21:43 | Re: Shared memory usage |
| Previous Message | Max Zorloff | 2007-08-25 22:22:23 | Re: Shared memory usage |