From: | Tapio Pitkäranta <Tapio(dot)Pitkaranta(at)relex(dot)fi> |
---|---|
To: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
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 08:10:18 |
Message-ID: | A771515B0F34E1488AE711874DE60566652DE07675@EX-MBS04.nbl.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
Thank you for the reply. It seems you might be right:
/etc/sysctl.conf
# Controls the maximum shared segment size, in bytes
kernel.shmmax = 68719476736
# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296
We have tried to set shared_buffers over 63 GB.
Do you have any advice on memory settings for servers with large amounts of memory (100-200GB)? It seems there is not too much documentation on that in the net.
Br,
Tapsa
--
Tapio Pitkäranta
RELEX Oy
Valimotie 27, 00380 Helsinki
puhelin: 050-5408550
email: tapio(dot)pitkaranta(at)relex(dot)fi
internet: http://www.relex.fi
-----Original Message-----
From: Devrim GÜNDÜZ [mailto:devrim(at)gunduz(dot)org]
Sent: 18. maaliskuuta 2011 9:22
To: Tapio Pitkäranta
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB?
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 | Nicholson, Brad (Toronto, ON, CA) | 2011-03-18 13:28:54 | Re: pg_stat_all_tables column value reseting problem. |
Previous Message | Devrim GÜNDÜZ | 2011-03-18 07:21:44 | Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of memory for DB? |