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