Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?

Поиск
Список
Период
Сортировка
От Devrim GÜNDÜZ
Тема Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?
Дата
Msg-id 1300432904.2930.16.camel@lenovo01-laptop03.gunduz.org
обсуждение исходный текст
Ответ на Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?  (Tapio Pitkäranta <Tapio.Pitkaranta@relex.fi>)
Ответы Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?
Список pgsql-admin
Дерево обсуждения 
On Thu, 2011-03-17 at 17:46 +0200, Tapio Pitkäranta wrote:

> We are running PostgreSQL 8.4 on a server with Linux CentOS with 144
> GB of memory.
>
> We have not been able to assign over 63 GB of memory for the Postgres:
> if we try to do that, we are not able to start the postgresql server
> process.

You are probably hitting kernel.shmmax value in /etc/sysctl.conf .

But... which parameter are you trying to set to 63GB?

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tapio Pitkäranta
Дата:
Сообщение: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?
Следующее
От: "Nicholson, Brad (Toronto, ON, CA)"
Дата:
Сообщение: Re: pg_stat_all_tables column value reseting problem.