Re: Signal 11

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

In response to

Browse pgsql-admin by date

  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