You're correct on trying and figuring the appropriate value of
shared_buffers for our application which I'd be doing. However, I wanted
to test how far I can get specially that 8.1 removed the limit of 2GB on
a 64-bit architecture like ours. The other thought is that my assumption
(which I may be wrong about) that the RDBMS (postgres in this case) will
do a better job managing and prioritizing the caching of objects, ie.
tables, data, etc than the kernel's cache which doesn't distinguish
indexes from tables,etc. I might be wrong on that (Linux kernel), but
that was my experience with Oracle on a Solaris box.
Thanks,
---
Husam Tomeh
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, December 14, 2005 2:38 PM
To: Tomeh, Husam
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] PG 8.1.1 Cannot allocate shared_buffers memory
error
"Tomeh, Husam" <htomeh@firstam.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
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may
containinformation that is legally privileged. If you are not the addressee, or the person responsible for delivering
itto the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is
strictlyprohibited. If you have received this message by mistake, please immediately notify us by replying to the
messageand delete the original message immediately thereafter.
Thank you.
FADLD Tag
**********************************************************************