From: | "Eric L(dot) Blevins" <eblevins(at)insight(dot)rr(dot)com> |
---|---|
To: | "Eric L(dot) Blevins" <eblevins(at)insight(dot)rr(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Signal 11 |
Date: | 2002-11-01 01:01:49 |
Message-ID: | 000e01c28142$451ba720$0201a8c0@Gateway |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
----- Original Message -----
From: "Eric L. Blevins" <eblevins(at)insight(dot)rr(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
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
www.wifimaps.com
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2002-11-01 01:54:12 | Re: [GENERAL] my.cnf to postgresql.conf Conversion |
Previous Message | Naomi Walker | 2002-11-01 00:36:07 | loading and unloading rows |