pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow should the correct value of shmmax be calculated for DWH (OLAP) server
4+ messages / 3 participants
[nested] [flat]
* How should the correct value of shmmax be calculated for DWH (OLAP) server
@ 2018-10-12 17:17 Shukla, Sumeet <ShuklaSu@advisory.com>
2018-10-15 07:43 ` Re: How should the correct value of shmmax be calculated for DWH (OLAP) server Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 4+ messages in thread
From: Shukla, Sumeet @ 2018-10-12 17:17 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: How should the correct value of shmmax be calculated for DWH (OLAP) server
2018-10-12 17:17 How should the correct value of shmmax be calculated for DWH (OLAP) server Shukla, Sumeet <ShuklaSu@advisory.com>
@ 2018-10-15 07:43 ` Laurenz Albe <laurenz.albe@cybertec.at>
2018-10-15 07:49 ` Re: How should the correct value of shmmax be calculated for DWH (OLAP) server Gunnar "Nick" Bluth <gunnar.bluth@pro-open.de>
0 siblings, 1 reply; 4+ messages in thread
From: Laurenz Albe @ 2018-10-15 07:43 UTC (permalink / raw)
To: Shukla, Sumeet <ShuklaSu@advisory.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: How should the correct value of shmmax be calculated for DWH (OLAP) server
2018-10-12 17:17 How should the correct value of shmmax be calculated for DWH (OLAP) server Shukla, Sumeet <ShuklaSu@advisory.com>
2018-10-15 07:43 ` Re: How should the correct value of shmmax be calculated for DWH (OLAP) server Laurenz Albe <laurenz.albe@cybertec.at>
@ 2018-10-15 07:49 ` Gunnar "Nick" Bluth <gunnar.bluth@pro-open.de>
2018-10-15 08:21 ` Re: How should the correct value of shmmax be calculated for DWH (OLAP) server Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 4+ messages in thread
From: Gunnar \"Nick\" Bluth @ 2018-10-15 07:49 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; Shukla, Sumeet <ShuklaSu@advisory.com>; pgsql-admin
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
Attachments:
0x3289338C.asc (application/pgp-keys, 1.7K) download
signature.asc (application/pgp-signature, 487B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: How should the correct value of shmmax be calculated for DWH (OLAP) server
2018-10-12 17:17 How should the correct value of shmmax be calculated for DWH (OLAP) server Shukla, Sumeet <ShuklaSu@advisory.com>
2018-10-15 07:43 ` Re: How should the correct value of shmmax be calculated for DWH (OLAP) server Laurenz Albe <laurenz.albe@cybertec.at>
2018-10-15 07:49 ` Re: How should the correct value of shmmax be calculated for DWH (OLAP) server Gunnar "Nick" Bluth <gunnar.bluth@pro-open.de>
@ 2018-10-15 08:21 ` Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 4+ messages in thread
From: Laurenz Albe @ 2018-10-15 08:21 UTC (permalink / raw)
To: Gunnar \"Nick\" Bluth <gunnar.bluth@pro-open.de>; Shukla, Sumeet <ShuklaSu@advisory.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-10-15 08:21 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-10-12 17:17 How should the correct value of shmmax be calculated for DWH (OLAP) server Shukla, Sumeet <ShuklaSu@advisory.com>
2018-10-15 07:43 ` Laurenz Albe <laurenz.albe@cybertec.at>
2018-10-15 07:49 ` Gunnar "Nick" Bluth <gunnar.bluth@pro-open.de>
2018-10-15 08:21 ` Laurenz Albe <laurenz.albe@cybertec.at>
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