Sv: Re: Fw: server hardware tuning.

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Sv: Re: Fw: server hardware tuning.
Дата
Msg-id VisenaEmail.38.73d479ddee0ddb2c.168b900e5e0@tc7-visena
обсуждение исходный текст
Ответ на Re: Fw: server hardware tuning.  (Prince Pathria <prince.pathria@goevive.com>)
Список pgsql-performance
På mandag 04. februar 2019 kl. 15:45:30, skrev Prince Pathria <prince.pathria@goevive.com>:
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
 
There's no such thing as PCIe SATA, use PCIe or NVMe in RAID-10, it's quite affordable these days and meaningless not to use.
 
--
Andreas Joseph Krogh

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

Предыдущее
От: Prince Pathria
Дата:
Сообщение: Re: Fw: server hardware tuning.
Следующее
От: Mariel Cherkassky
Дата:
Сообщение: Re: ERROR: found xmin from before relfrozenxid