High-end PG database configuration help

From: "Gupta, Amar Nath" <angupta(at)corbus(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: High-end PG database configuration help
Date: 2016-07-20 10:45:02
Message-ID: D8FBDBAB4D0ECF4FB63140011F7D21A201ADB495B2@CRUSEXMBX02.corbus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Maki Smith (US - IFS) 2016-07-20 11:09:24 Re: running postgresql with a different id other than postgres user
Previous Message Wolfgang Wilhelm 2016-07-20 08:12:53 Re: running postgresql with a different id other than postgres user