From: Carl Youngblood <carl@youngbloods.org>
To: pgsql-performance@postgresql.org
Subject: Re: Beginner optimization questions, esp. regarding Tsearch2
Date: Wed, 16 Aug 2006 09:34:24 -0600
Message-ID: <e5ed7b690608160834h2560dceg326f6db7be668e87@mail.gmail.com> (raw)
In-Reply-To: <20060815192145.GI21363@pervasive.com>
References: <e5ed7b690608092100v43590a8epdbdec7afa847c722@mail.gmail.com>
<44DAFB2B.4070307@archonet.com>
<20060815150529.GO27928@pervasive.com>
<e5ed7b690608151147o7f65132do3b9d301f8b2ebc65@mail.gmail.com>
<20060815192145.GI21363@pervasive.com>
The relevant portion of my sysctl.conf file looks like this:
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
I understood it was a good idea to set shmmax to half of available
memory (2GB in this case). I assume that I need to set shared_buffers
slightly lower than 2GB for postgresql to start successfully.
Carl
On 8/15/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
> On Tue, Aug 15, 2006 at 12:47:54PM -0600, Carl Youngblood wrote:
> > I tried setting it to 2GB and postgres wouldn't start. Didn't
> > investigate in much greater detail as to why it wouldn't start, but
> > after switching it back to 1GB it started fine.
>
> Most likely because you didn't set the kernel's shared memory settings
> high enough.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: carl@youngbloods.org
Subject: Re: Beginner optimization questions, esp. regarding Tsearch2
In-Reply-To: <e5ed7b690608160834h2560dceg326f6db7be668e87@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox