Re: Fw: server hardware tuning.

Поиск
Список
Период
Сортировка
От Prince Pathria
Тема Re: Fw: server hardware tuning.
Дата
Msg-id CAON0Day=M6164EehJo1M-CS95c22fpGrArm_pVwJ9tjzaRYujg@mail.gmail.com
обсуждение исходный текст
Ответ на Fw: server hardware tuning.  (suganthi Sekar <suganthi@uniphore.com>)
Ответы Sv: Re: Fw: server hardware tuning.  (Andreas Joseph Krogh <andreas@visena.com>)
Список pgsql-performance
Дерево обсуждения
Hi Suganthi,
I can give you a start, some pro users can suggest you better.

1. Don't use this much of connections on a single postgres server. Use a connection pooler in front of it.
2. RAM: Depends upon how much data you want to be cached.
3. Use PCIe SATA SSD with RAID10, Postgres uses a lot of IO for its operations. 
4. For config tuning: https://pgtune.leopard.in.ua/#/ Though please go through all params for more understanding

Happy to help :)
Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com


On Mon, Feb 4, 2019 at 6:07 PM suganthi Sekar <suganthi@uniphore.com> wrote:


Hi ,


I need know how to calculate hardware sizing for database or query


RAM

CPU

Config tuning


Requirement : 


1100 concurrent connection

1600 column of table

1GB of data can be select and dynamic aggregation will happen


Regards

SuganthiSekar

В списке pgsql-performance по дате отправления:

Предыдущее
От: suganthi Sekar
Дата:
Сообщение: Fw: server hardware tuning.
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Sv: Re: Fw: server hardware tuning.