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.
|
| Список | 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
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 по дате отправления: