| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Christiaan Willemsen <cwillemsen(at)technocon(dot)com> |
| Cc: | Bill Moran <wmoran(at)collaborativefusion(dot)com>, Isak Hansen <isak(dot)hansen(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: FreeBSD 7 needing to allocate lots of shared memory |
| Date: | 2008-11-18 18:11:11 |
| Message-ID: | 22121.1227031871@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Christiaan Willemsen <cwillemsen(at)technocon(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Phoenix Kiula | 2008-11-18 18:18:36 | Any risks in using FUNCTIONs (stored procedures) instead of raw sql queries? |
| Previous Message | Pavel Stehule | 2008-11-18 18:05:51 | Re: Foreign Key 'walker'? |