RE: Memory and hard ware calculation :

[Rangaraj G <rangaraj@xxxxxxxxxxxx>]

Hi,

 

My question  

Our connection is 1100 parallel connection and 1 GB I/p data and 1 GB o/p data in each connection, currently we are using 64 GB RAM and 8 core.

 

But we need all the reports below 3 seconds.

 

So kindly suggest expanding my hard ware and work memory.

 

Is there any possibility to get your mobile number ?

 

Regards,

RANGARAJ G

 

 

From: Cleiton Luiz Domazak <cleitondomazak@xxxxxxxxx>
Sent: Monday, January 21, 2019 11:13 PM
To: Rangaraj G <rangaraj@xxxxxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx; robertmhaas@xxxxxxxxx; pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: Memory and hard ware calculation :

 

 

 

On Mon, Jan 21, 2019 at 5:35 PM Rangaraj G <rangaraj@xxxxxxxxxxxx> wrote:

Hi,

 

Memory and hard ware calculation :

 

 

How much memory required to achieve performance with the 6GB RAM, 8 Core, Max connection 1100 concurrent connection and O/p memory from procedure 1GB ?

 

https://pgtune.leopard.in.ua/#/ 

 

Is there any changes required in hardware and work memory expansion ?  

 

 

Regards

RANGARAJ G