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

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

In response to

Responses

Browse pgsql-admin by date

  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?