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 <cleitondoma...@gmail.com> Sent: Monday, January 21, 2019 11:13 PM To: Rangaraj G <ranga...@uniphore.com> Cc: pgsql-gene...@postgresql.org; robertmh...@gmail.com; pgsql-performa...@postgresql.org Subject: Re: Memory and hard ware calculation : On Mon, Jan 21, 2019 at 5:35 PM Rangaraj G <ranga...@uniphore.com<mailto:ranga...@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