Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gm2If-0005e9-JZ for pgsql-general@arkaria.postgresql.org; Tue, 22 Jan 2019 20:05:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gm2Ie-0000tX-EK for pgsql-general@arkaria.postgresql.org; Tue, 22 Jan 2019 20:05:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gm2Ie-0000sq-4g for pgsql-general@lists.postgresql.org; Tue, 22 Jan 2019 20:05:32 +0000 Received: from mail-ot1-x336.google.com ([2607:f8b0:4864:20::336]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gm2Ib-0006X6-JI for pgsql-general@lists.postgresql.org; Tue, 22 Jan 2019 20:05:31 +0000 Received: by mail-ot1-x336.google.com with SMTP id e12so24840022otl.5 for ; Tue, 22 Jan 2019 12:05:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=O8WllIOPQ1Rxv3CIKyIZLn0vK0s+YZqxOCDBv20nQdc=; b=tmolxgamszgQ54jPeApYGn4C/3gz4bLNjtbdMrGXWdCn1OESKNIRD26p9LRkwRe/g5 5Vg2vrgj3GZtRgcg1lgJSQF8aSJoGh5Tcd34Nlm3D0ouqvRT90KVjXe9xCj8E9fRhk+t 33rHcy8FN9uDr8UrgvncuJkv7Ccq2jMyLgGn8KvhIyXhkHqX6GdQoJSb1hXlBFRhGv5u cjIm0yUcKTdd4L+JcEG1pv/N9y9a1w+yNnIaEd9bxL9p8jLELQnAuQftuHjQZ/8TkTkl Xx2qKWhmDzr2rPEe+AIaQq8sOIlElXx6Bt4t1bqVuqNgLf5c20Rb9nt6jkKLP/KCK2cq ebOQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=O8WllIOPQ1Rxv3CIKyIZLn0vK0s+YZqxOCDBv20nQdc=; b=jzP+GG4YCxSct9X4XTIDeQgDwkHz8hXeIPSGC2NH/LwHPiqp2o5nC1Al2hevcjHzDQ 9m2dVRTpue0MpCra+WSc2yWktJv+WvsqOaaC89PFzgpWw/4YqdXgAbP7hOvj9nqty9Fk bW5GYq/31F61JGf31J7KFtVSYAS0M0szN37SA5sthr7hQ2l1UNBc2bfv4aHEca/uoAHy mSNpZZ3BiPXqlebEXaNSnBlr4Xr7JKCg10aGUCo6m49TPuHxnl9uz6KmT9APFpXxe7oA XiF4YjoLYsmWFjwbfwPghc9lK+FApvwHSTRo7CrxEmolIaeoLkQmQr5/ydouNF58pYQB 7FvA== X-Gm-Message-State: AJcUukdljem3uGFlZUGQfrkMGjLgOna7kxsMaOLHxGSN7WwNAxm2+DUN kS2TKI9C9WP9a1JCXkvfF4GjYIwH X-Google-Smtp-Source: ALg8bN5IvMBiLR8qGKYOzugNZRTl3XBnk4MMHl8wBnsrh4RInMaPrsxNl0oDsFXYS3OFvTh3hYXfHQ== X-Received: by 2002:a9d:6293:: with SMTP id x19mr24309306otk.133.1548187527495; Tue, 22 Jan 2019 12:05:27 -0800 (PST) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id o2sm7399870otj.2.2019.01.22.12.05.26 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 22 Jan 2019 12:05:26 -0800 (PST) Subject: Re: Memory and hard ware calculation : To: pgsql-general@lists.postgresql.org References: From: Ron Message-ID: Date: Tue, 22 Jan 2019 14:05:25 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.2.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------28CBBFE12382C56A5201B872" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------28CBBFE12382C56A5201B872 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit 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 > *Sent:* Monday, January 21, 2019 11:13 PM > *To:* Rangaraj G > *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 > 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. --------------28CBBFE12382C56A5201B872 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
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> 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

 


--
Angular momentum makes the world go 'round.
--------------28CBBFE12382C56A5201B872--