Postgres Pro
Downloads
Home   >   mailing lists

Re: How should the correct value of shmmax be calculated for DWH(OLAP) server - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: How should the correct value of shmmax be calculated for DWH(OLAP) server
Date
Msg-id 4647b0c67c2c5d4dc08032f1b11240665711af95.camel@cybertec.at
Whole thread Raw
In response to How should the correct value of shmmax be calculated for DWH (OLAP)server  ("Shukla, Sumeet" <ShuklaSu@advisory.com>)
Responses Re: How should the correct value of shmmax be calculated for DWH(OLAP) server
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Pierre Ochsenbein
Date:
Subject: pgpool versus which tool?
Next
From: "Gunnar \"Nick\" Bluth"
Date:
Subject: Re: How should the correct value of shmmax be calculated for DWH(OLAP) server