Thread: How should the correct value of shmmax be calculated for DWH (OLAP)server

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

Shukla, Sumeet wrote:
> Can someone please help me determine the appropriate value of kernel shmmax
> parameter for PostgreSQL configured for Data Warehouse use?

Simple. Set it to anything bigger than your "shared_buffers" setting.
If PostgreSQL manages to start, your setting is big enough.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

Am 15.10.2018 um 09:43 schrieb Laurenz Albe:
> Shukla, Sumeet wrote:
>> Can someone please help me determine the appropriate value of kernel shmmax
>> parameter for PostgreSQL configured for Data Warehouse use?
>
> Simple. Set it to anything bigger than your "shared_buffers" setting.
> If PostgreSQL manages to start, your setting is big enough.
>

As a matter of fact, you shouldn't need to set SHMMAX anyway, unless you
tampered with "dynamic_shared_memory_type" or you are on a very exotic
OS ;-)

Best regards,
--
Gunnar "Nick" Bluth
RHCE/SCLA

Mobil +49 172 8853339
Email: gunnar.bluth@pro-open.de
_____________________________________________________________
In 1984 mainstream users were choosing VMS over UNIX.
Ten years later they are choosing Windows over UNIX.
What part of that message aren't you getting? - Tom Payne

Gunnar "Nick" Bluth wrote:
> Am 15.10.2018 um 09:43 schrieb Laurenz Albe:
> > Shukla, Sumeet wrote:
> >> Can someone please help me determine the appropriate value of kernel shmmax
> >> parameter for PostgreSQL configured for Data Warehouse use?
> > 
> > Simple. Set it to anything bigger than your "shared_buffers" setting.
> > If PostgreSQL manages to start, your setting is big enough.
> > 
> 
> As a matter of fact, you shouldn't need to set SHMMAX anyway, unless you
> tampered with "dynamic_shared_memory_type" or you are on a very exotic
> OS ;-)

True, I was living in the past.  Thanks for the correction.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com