I would appreciate, if anyone provide me some guidance
Best,
Amar
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Gupta, Amar Nath
Sent: 20 July 2016 11:45
To: pgsql-admin@postgresql.org
Subject: [ADMIN] High-end PG database configuration help
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.
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.
