High-end PG database configuration help

Поиск
Список
Период
Сортировка
От Gupta, Amar Nath
Тема High-end PG database configuration help
Дата
Msg-id D8FBDBAB4D0ECF4FB63140011F7D21A201ADB495B2@CRUSEXMBX02.corbus.com
обсуждение исходный текст
Ответы Re: High-end PG database configuration help
Re: High-end PG database configuration help
Список 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 по дате отправления:

Предыдущее
От: Wolfgang Wilhelm
Дата:
Сообщение: Re: running postgresql with a different id other than postgres user
Следующее
От: "Maki Smith (US - IFS)"
Дата:
Сообщение: Re: running postgresql with a different id other than postgres user