Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Neil ConwayDate: 2002-11-01 01:54:12
Subject: Re: [GENERAL] my.cnf to postgresql.conf Conversion
Previous:From: Naomi WalkerDate: 2002-11-01 00:36:07
Subject: loading and unloading rows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group