RE: Memory and hard ware calculation :

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(at)gmail(dot)com>
Sent: Monday, January 21, 2019 11:13 PM
To: Rangaraj G <rangaraj(at)uniphore(dot)com>
Cc: pgsql-general(at)postgresql(dot)org; robertmhaas(at)gmail(dot)com; pgsql-performance(at)postgresql(dot)org
Subject: Re: Memory and hard ware calculation :

On Mon, Jan 21, 2019 at 5:35 PM Rangaraj G <rangaraj(at)uniphore(dot)com<mailto:rangaraj(at)uniphore(dot)com>> 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