Re: Advice/guideline on increasing shared_buffers and kernel parameters

Поиск
Список
Период
Сортировка
От Jan Lentfer
Тема Re: Advice/guideline on increasing shared_buffers and kernel parameters
Дата
Msg-id 0c25e051a7d7268b163c0d120326ee59@neslonek.homeunix.org
обсуждение исходный текст
Ответ на Re: Advice/guideline on increasing shared_buffers and kernel parameters  ("Gnanakumar" <gnanam@zoniac.com>)
Список 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 по дате отправления:

Предыдущее
От: "Gnanakumar"
Дата:
Сообщение: Re: Advice/guideline on increasing shared_buffers and kernel parameters
Следующее
От: "Fred Parkinson"
Дата:
Сообщение: retaining useful information on my screen