Postgres Pro
Downloads
Home   >   mailing lists

RE: Memory and hard ware calculation : - Mailing list pgsql-general

From Rangaraj G
Subject RE: Memory and hard ware calculation :
Date
Msg-id SG2PR01MB31250DAFE85E2F5B5A76B55EA5980@SG2PR01MB3125.apcprd01.prod.exchangelabs.com
Whole thread Raw
In response to Re: Memory and hard ware calculation :  (Cleiton Luiz Domazak <cleitondomazak@gmail.com>)
Responses Re: Memory and hard ware calculation :
List pgsql-general
Tree view

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

 

 

 

On Mon, Jan 21, 2019 at 5:35 PM Rangaraj G <rangaraj@uniphore.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 ?

 

 

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

 

 

Regards

RANGARAJ G

 

pgsql-general by date:

Previous
From: "Jamison, Kirk"
Date:
Subject: RE: Tuning threshold for BAS_BULKREAD (large tables)
Next
From: Josef Machytka
Date:
Subject: PostgreSQL logical replication depends on WAL segments?