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.pitkaranta@xxxxxxxx internet: http://www.relex.fi -----Original Message----- From: Devrim GÃNDÃZ [mailto:devrim@xxxxxxxxxx] Sent: 18. maaliskuuta 2011 9:22 To: Tapio PitkÃranta Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
