Re: PG 8.1.1 Cannot allocate shared_buffers memory error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PG 8.1.1 Cannot allocate shared_buffers memory error
Date: 2005-12-14 22:38:05
Message-ID: 7427.1134599885@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Tomeh, Husam" <htomeh(at)firstam(dot)com> writes:
> I just installed postgres 8.1.1 on a dual optron Linux box running Linux
> 4 advanced server, with 32GB of RAM and 2GB of swap.
> I'm trying to allocate 24 GB as shared_bufferes. I'm getting an error
> that I can not allocate memory (see below).

While this doesn't answer your question: why are you trying to do that?
AFAIK there is no evidence whatever that that's a good idea. Try
measuring performance at, say, 1Gb, 8Gb, 16Gb of shared buffers and see
where the trend is going before you waste a lot of time fixing the kernel
parameters.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tomeh, Husam 2005-12-14 22:49:17 Re: PG 8.1.1 Cannot allocate shared_buffers memory
Previous Message Tomeh, Husam 2005-12-14 22:08:58 PG 8.1.1 Cannot allocate shared_buffers memory error