Re: FreeBSD 7 needing to allocate lots of shared memory - Mailing list pgsql-general

From Tom Lane
Subject Re: FreeBSD 7 needing to allocate lots of shared memory
Date
Msg-id 22121.1227031871@sss.pgh.pa.us
Whole thread Raw
In response to Re: FreeBSD 7 needing to allocate lots of shared memory  (Christiaan Willemsen <cwillemsen@technocon.com>)
List pgsql-general
Christiaan Willemsen <cwillemsen@technocon.com> writes:
> Tom Lane wrote:
>> I'm wondering about the shmall setting myself.  The Postgres docs
>> suggest that FreeBSD measures shmall in pages.  If so, the above
>> setting is far too large and is perhaps resulting in an internal
>> overflow in the kernel.
>>
> Hmm, might be.. I can try lowering the value, but if this is the problem
> what is max?

No idea, but I'd recommend setting it to physical RAM measured in pages.
Not sure what FreeBSD uses as page size though.

            regards, tom lane

pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: Foreign Key 'walker'?
Next
From: "Phoenix Kiula"
Date:
Subject: Any risks in using FUNCTIONs (stored procedures) instead of raw sql queries?