From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Memory and hard ware calculation :
Date: Tue, 22 Jan 2019 14:05:25 -0600
Message-ID: <b930a400-b1e1-4820-cd33-8c8e83d531de@gmail.com> (raw)
In-Reply-To: <SG2PR01MB31250DAFE85E2F5B5A76B55EA5980@SG2PR01MB3125.apcprd01.prod.exchangelabs.com>
References: <SG2PR01MB3125ECE0241F24C18B237BECA59F0@SG2PR01MB3125.apcprd01.prod.exchangelabs.com>
<CAKx1C8Hr7MM1Sm3zeH3Uy-+V22XPgkKRMBbM4DBdh36viKrK4Q@mail.gmail.com>
<SG2PR01MB31250DAFE85E2F5B5A76B55EA5980@SG2PR01MB3125.apcprd01.prod.exchangelabs.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: Memory and hard ware calculation :
In-Reply-To: <b930a400-b1e1-4820-cd33-8c8e83d531de@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox