Postgres Pro
Downloads
Home   >   mailing lists

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

From Shukla, Sumeet
Subject How should the correct value of shmmax be calculated for DWH (OLAP)server
Date
Msg-id BBF9115E-9E39-4710-B9EF-AE41EF576F38@advisory.com
Whole thread Raw
Responses Re: How should the correct value of shmmax be calculated for DWH(OLAP) server  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view

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.

pgsql-admin by date:

Previous
From: Shrikant Bhende
Date:
Subject: FATAL: terminating connection because protocol synchronization was lost
Next
From: pavan95
Date:
Subject: Re: Hick ups in Postgresql Logical Replication