From: wangqi <wangqi@edgesoft.cn>
To: pgsql-admin@postgresql.org
Subject: about shared_buffer and kernel.shmmax
Date: Thu, 21 Jun 2012 11:38:31 +0800
Message-ID: <4FE29737.2040405@edgesoft.cn> (raw)
Hi everybody,
shared_buffer maximum limit is ?
I set shared_buffer more than 250G, I got error at startup pg.
------------------------------------------------------------------------
This error usually means that PostgreSQL's request for a shared memory
segment exceeded your kernel's SHMMAX parameter. You can either reduce
the request size or reconfigure the kernel with larger SHMMAX. To reduce
the request size (currently 439371702272 bytes), reduce PostgreSQL's
shared_buffers parameter (currently 52428800) and/or its max_connections
parameter (currently 104).
-------------------------------------------------------------------------
but now
kernel.shmmax = 966367641600
kernel.shmall = 235929600
--
----------------------------------------------------
Yours sincerely,
Qi Wang
Edgesoft (China) Co.,Ltd
F26th Block B,Zhongli Building,
No.32 Huoju Road,
Hi-Tech Zone,Dalian,China
Zip:116023
Tel:+86-411-84753511
Fax:+86-411-84753577
http://www.edgesoft.cn
mailto:wangqi@edgesoft.cn
----------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: wangqi@edgesoft.cn
Subject: Re: about shared_buffer and kernel.shmmax
In-Reply-To: <4FE29737.2040405@edgesoft.cn>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox