| From: | "Shukla, Sumeet" <ShuklaSu(at)advisory(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | How should the correct value of shmmax be calculated for DWH (OLAP) server |
| Date: | 2018-10-12 17:17:50 |
| Message-ID: | BBF9115E-9E39-4710-B9EF-AE41EF576F38@advisory.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pavan95 | 2018-10-13 16:22:21 | Re: Hick ups in Postgresql Logical Replication |
| Previous Message | Shrikant Bhende | 2018-10-12 15:27:32 | FATAL: terminating connection because protocol synchronization was lost |