From: | "Gunnar \"Nick\" Bluth" <gunnar(dot)bluth(at)pro-open(dot)de> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "Shukla, Sumeet" <ShuklaSu(at)advisory(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: How should the correct value of shmmax be calculated for DWH (OLAP) server |
Date: | 2018-10-15 07:49:02 |
Message-ID: | 5BC4466E.7070902@pro-open.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)bluth(at)pro-open(dot)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
Attachment | Content-Type | Size |
---|---|---|
0x3289338C.asc | application/pgp-keys | 1.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kirkwood | 2018-10-15 08:16:14 | Re: Commit not required for update statement |
Previous Message | Laurenz Albe | 2018-10-15 07:43:45 | Re: How should the correct value of shmmax be calculated for DWH (OLAP) server |