Postgres Pro
Downloads
Home   >   mailing lists

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

From Devrim GÜNDÜZ
Subject Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?
Date
Msg-id 1300432904.2930.16.camel@lenovo01-laptop03.gunduz.org
Whole thread Raw
In response to Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?  (Tapio Pitkäranta <Tapio.Pitkaranta@relex.fi>)
Responses Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?  (Tapio Pitkäranta <Tapio.Pitkaranta@relex.fi>)
List pgsql-admin
Tree view 
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
Attachment

pgsql-admin by date:

Previous
From: Tapio Pitkäranta
Date:
Subject: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?
Next
From: "Nicholson, Brad (Toronto, ON, CA)"
Date:
Subject: Re: pg_stat_all_tables column value reseting problem.