High-end PG database configuration help - Mailing list pgsql-admin

From Gupta, Amar Nath
Subject High-end PG database configuration help
Date
Msg-id D8FBDBAB4D0ECF4FB63140011F7D21A201ADB495B2@CRUSEXMBX02.corbus.com
Whole thread Raw
Responses Re: High-end PG database configuration help
Re: High-end PG database configuration help
List pgsql-admin

Hello,

 

I am working to configure high end PostgreSQL database, and need some help.

 

Please can you suggest me best and optimal configuration for “postgresql.conf” I should use.

 

DB server details:

·         PostgreSQL Version: 9.5.3

·         Disc: RAID 10 (1 TB)

·         DB Size: 250GB

·         RAM: 256GB

·         CPU(s): 48

·         Max Connection: 2000

·         OS: CentOS release 6.6 (Final)

 

Many thanks in advanced.

 

Best Regards,

Amar

 

Confidentiality Notice

This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged, confidential or otherwise legally exempt from disclosure.

If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately either by phone (937-226-7724) or reply to this e-mail and delete all copies of this message.

pgsql-admin by date:

Previous
From: Wolfgang Wilhelm
Date:
Subject: Re: running postgresql with a different id other than postgres user
Next
From: "Maki Smith (US - IFS)"
Date:
Subject: Re: running postgresql with a different id other than postgres user