Sv: Re: Fw: server hardware tuning.

På mandag 04. februar 2019 kl. 15:45:30, skrev Prince Pathria < [email protected] >: 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.

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

Fw: server hardware tuning.

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