[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] postgres start problems with memory
From: Josh Close <narshe () gmail ! com>
Date: 2004-09-30 20:50:22
Message-ID: 4a0cafe204093013507fc6c35f () mail ! gmail ! com
[Download RAW message or body]
On 30 Sep 2004 16:40:58 -0400, Greg Stark <gsstark@mit.edu> wrote:
>
> Josh Close <narshe@gmail.com> writes:
>
> > To reduce the request size (currently 34037760 bytes),
> ...
> > root # sysctl -a | grep shm
> > kernel.shmmni = 4096
> > kernel.shmall = 31584400
> > kernel.shmmax = 31584400
>
> So it's currently looking for 34M and you're setting the maximum to 31M.
>
> --
> greg
We'll, you're definitely right about that. Is there a certain standard
to this? Say if I use the "reasonable value" formula. What would be a
good size for the buffer then? Should it be a certain %age of
available RAM?
-Josh
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic