Обсуждение: How should the correct value of shmmax be calculated for DWH (OLAP)server
Hi,
Can someone please help me determine the appropriate value of kernel shmmax parameter for PostgreSQL configured for Data Warehouse use?
I have 48 GB RAM on the server and max_connections set to 500
Thanks & Regards,
Sumeet Shukla | Database Administrator
ADO – Application & Database Operations
Mob: +91 740 612 1115 | Desk: +91 44 6121 8446
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
Re: How should the correct value of shmmax be calculated for DWH(OLAP) server
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