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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "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:43:45
Message-ID: 4647b0c67c2c5d4dc08032f1b11240665711af95.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gunnar "Nick" Bluth 2018-10-15 07:49:02 Re: How should the correct value of shmmax be calculated for DWH (OLAP) server
Previous Message Pierre Ochsenbein 2018-10-15 07:38:47 pgpool versus which tool?