Re: High-end PG database configuration help

I would appreciate, if anyone provide me some guidance

Best,

Amar

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.