Re: Advice/guideline on increasing shared_buffers and kernel parameters - Mailing list pgsql-admin

From Jan Lentfer
Subject Re: Advice/guideline on increasing shared_buffers and kernel parameters
Date
Msg-id 0c25e051a7d7268b163c0d120326ee59@neslonek.homeunix.org
Whole thread Raw
In response to Re: Advice/guideline on increasing shared_buffers and kernel parameters  ("Gnanakumar" <gnanam@zoniac.com>)
List pgsql-admin
On Tue, 8 May 2012 14:56:52 +0530, Gnanakumar wrote:

> As you can see, in my case, I'm setting only 3 GB (3072 MB), which is
> actually below 8 GB.  So, I need to increase kernel parameters in
> this
> case. Any ideas/insights?

I am not using CentOS (or Linux at all), but

edit /etc/sysctl.conf

and do something like /etc/init.d/sysctl restart


also some quick googling braught this up:
http://grokbase.com/t/centos/centos/11a40897q1/centos-6-increase-shared-memory-limits-permanently

Judging from your error you should set shmmax to something in the range
of 3670016000


Jan

--
professional: http://www.oscar-consult.de
private: http://neslonek.homeunix.org/drupal/


pgsql-admin by date:

Previous
From: "Gnanakumar"
Date:
Subject: Re: Advice/guideline on increasing shared_buffers and kernel parameters
Next
From: "Fred Parkinson"
Date:
Subject: retaining useful information on my screen