Re: Memory and hard ware calculation :

[Ron <ronljohnsonjr@xxxxxxxxx>]

Have you analyzed the queries to ensure that they are efficient?
Have you examined the tables to ensure that they have indexes to support the joins?
Have you minimized the amount of data selected?

On 1/22/19 6:54 AM, Rangaraj G wrote:

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

 

--
Angular momentum makes the world go 'round.