----- Original Message -----
From: "Eric L. Blevins" <eblevins(at)insight(dot)rr(dot)com>
Sent: Thursday, October 31, 2002 11:15 AM
Subject: Re: [ADMIN] Signal 11
> From: "Andrew Sullivan" <andrew(at)libertyrms(dot)info>
> To: "Eric L. Blevins" <eblevins(at)insight(dot)rr(dot)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
In response to
pgsql-admin by date
|Next:||From: Neil Conway||Date: 2002-11-01 01:54:12|
|Subject: Re: [GENERAL] my.cnf to postgresql.conf Conversion|
|Previous:||From: Naomi Walker||Date: 2002-11-01 00:36:07|
|Subject: loading and unloading rows|