----- Original Message -----
From: "Eric L. Blevins" <eblevins@insight.rr.com>
To: <pgsql-admin@postgresql.org>
Sent: Thursday, October 31, 2002 11:15 AM
Subject: Re: [ADMIN] Signal 11
> From: "Andrew Sullivan" <andrew@libertyrms.info>
> To: "Eric L. Blevins" <eblevins@insight.rr.com>
> Sent: Thursday, October 31, 2002 10:33 AM
> Subject: Re: [ADMIN] Signal 11
>
>
> >
> > Have you checked your physical memory for flaws?
> >
> Yes, I have checked the memory, it is fine.
> We had so much trouble we replaced the innards of the server.
> New PS, MB, Processor, and RAM
> Still have the exact same problem.
We got it working finally
1. We installed a kernel made for large memory machines from an RPM
2. in /etc/sysctl.conf
we added the following 3 lines
kernel.shmall = 805306368
kernel.shmmax = 805306368
kernel.shmmni = 8192
kernel.sem = 250 32000 100 128
3. In postgresql.conf
we set the shared_buffers to 50000
She is working flawless and very fast now.
Just the performance we needed!
Eric L. Blevins
www.wifimaps.com