Re: Advice/guideline on increasing shared_buffers and kernel parameters

From: Jan Lentfer <Jan(dot)Lentfer(at)web(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Advice/guideline on increasing shared_buffers and kernel parameters
Date: 2012-05-08 10:32:33
Message-ID: 0c25e051a7d7268b163c0d120326ee59@neslonek.homeunix.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Fred Parkinson 2012-05-08 14:28:32 retaining useful information on my screen
Previous Message Gnanakumar 2012-05-08 09:26:52 Re: Advice/guideline on increasing shared_buffers and kernel parameters