Sv: Re: Fw: server hardware tuning.

2019-02-04 Thread Andreas Joseph Krogh
På mandag 04. februar 2019 kl. 15:45:30, skrev Prince Pathria < prince.path...@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

Re: Fw: server hardware tuning.

2019-02-04 Thread Prince Pathria
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