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
?

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

Hi,

As per '1100 concurrent connections' I think you want to have a close
look to your CPU.

It looks to me a lot of connections, much more than what 8 cores can
handle and you will probably end up in a situation where your CPU spends
a lot of time in handling the connections rather than serving them.

regards,

fabio pardi

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<mailto: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 ?

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

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

Regards
RANGARAJ G

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@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
<mailto: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 ?

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.