pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedMemory and hard ware calculation :
5+ messages / 4 participants
[nested] [flat]
* Memory and hard ware calculation :
@ 2019-01-21 11:24 Rangaraj G <rangaraj@uniphore.com>
2019-01-21 17:43 ` Re: Memory and hard ware calculation : Cleiton Luiz Domazak <cleitondomazak@gmail.com>
2019-01-22 08:11 ` Re: Memory and hard ware calculation : Fabio Pardi <f.pardi@portavita.eu>
0 siblings, 2 replies; 5+ messages in thread
From: Rangaraj G @ 2019-01-21 11:24 UTC (permalink / raw)
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>; robertmhaas@gmail.com <robertmhaas@gmail.com>; pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Memory and hard ware calculation :
2019-01-21 11:24 Memory and hard ware calculation : Rangaraj G <rangaraj@uniphore.com>
@ 2019-01-21 17:43 ` Cleiton Luiz Domazak <cleitondomazak@gmail.com>
2019-01-22 12:54 ` RE: Memory and hard ware calculation : Rangaraj G <rangaraj@uniphore.com>
1 sibling, 1 reply; 5+ messages in thread
From: Cleiton Luiz Domazak @ 2019-01-21 17:43 UTC (permalink / raw)
To: Rangaraj G <rangaraj@uniphore.com>; +Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>; robertmhaas@gmail.com <robertmhaas@gmail.com>; pgsql-performance
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/#/
>
>
> Is there any changes required in hardware and work memory expansion ?
>
>
>
>
>
> Regards
>
> RANGARAJ G
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Memory and hard ware calculation :
2019-01-21 11:24 Memory and hard ware calculation : Rangaraj G <rangaraj@uniphore.com>
2019-01-21 17:43 ` Re: Memory and hard ware calculation : Cleiton Luiz Domazak <cleitondomazak@gmail.com>
@ 2019-01-22 12:54 ` Rangaraj G <rangaraj@uniphore.com>
2019-01-22 20:05 ` Re: Memory and hard ware calculation : Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Rangaraj G @ 2019-01-22 12:54 UTC (permalink / raw)
To: Cleiton Luiz Domazak <cleitondomazak@gmail.com>; +Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>; robertmhaas@gmail.com <robertmhaas@gmail.com>; pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Memory and hard ware calculation :
2019-01-21 11:24 Memory and hard ware calculation : Rangaraj G <rangaraj@uniphore.com>
2019-01-21 17:43 ` Re: Memory and hard ware calculation : Cleiton Luiz Domazak <cleitondomazak@gmail.com>
2019-01-22 12:54 ` RE: Memory and hard ware calculation : Rangaraj G <rangaraj@uniphore.com>
@ 2019-01-22 20:05 ` Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Ron @ 2019-01-22 20:05 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Memory and hard ware calculation :
2019-01-21 11:24 Memory and hard ware calculation : Rangaraj G <rangaraj@uniphore.com>
@ 2019-01-22 08:11 ` Fabio Pardi <f.pardi@portavita.eu>
1 sibling, 0 replies; 5+ messages in thread
From: Fabio Pardi @ 2019-01-22 08:11 UTC (permalink / raw)
To: pgsql-performance@lists.postgresql.org
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
On 1/21/19 12:24 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 ?
>
>
>
>
>
> Is there any changes required in hardware and work memory expansion ?
>
>
>
>
>
> Regards
>
> RANGARAJ G
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2019-01-22 20:05 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-01-21 11:24 Memory and hard ware calculation : Rangaraj G <rangaraj@uniphore.com>
2019-01-21 17:43 ` Cleiton Luiz Domazak <cleitondomazak@gmail.com>
2019-01-22 12:54 ` Rangaraj G <rangaraj@uniphore.com>
2019-01-22 20:05 ` Ron <ronljohnsonjr@gmail.com>
2019-01-22 08:11 ` Fabio Pardi <f.pardi@portavita.eu>
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