Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group