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

From Scott Whitney
Subject Re: High-end PG database configuration help
Date
Msg-id mnnt7piu3jrpl24pl8tinohr.1469135669709@email.android.com
Whole thread Raw
In response to High-end PG database configuration help  ("Gupta, Amar Nath" <angupta@corbus.com>)
List pgsql-admin
I would be happy to consult on this.


Your requirements are vague. 


-------- Original message --------
From: "Gupta, Amar Nath" <angupta@corbus.com>
Date: 07/21/2016 4:03 PM (GMT-06:00)
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] High-end PG database configuration help

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.



Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com

p 512.834.8888 
f 512-834-8858 

Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/ 

pgsql-admin by date:

Previous
From: "Gupta, Amar Nath"
Date:
Subject: Re: High-end PG database configuration help
Next
From: "David G. Johnston"
Date:
Subject: Re: High-end PG database configuration help