| From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
|---|---|
| To: | Tapio Pitkäranta <Tapio(dot)Pitkaranta(at)relex(dot)fi> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB? |
| Date: | 2011-03-18 07:21:44 |
| Message-ID: | 1300432904.2930.16.camel@lenovo01-laptop03.gunduz.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tapio Pitkäranta | 2011-03-18 08:10:18 | Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB? |
| Previous Message | leslie samuel | 2011-03-18 05:16:42 | Re: pg_stat_all_tables column value reseting problem. |