| From: | Fabio Pardi <f(dot)pardi(at)portavita(dot)eu> |
|---|---|
| To: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Memory and hard ware calculation : |
| Date: | 2019-01-22 08:11:15 |
| Message-ID: | db537968-f959-7b14-3264-8a705c0bf422@portavita.eu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2019-01-22 08:36:28 | Re: Tuning threshold for BAS_BULKREAD (large tables) |
| Previous Message | Jamison, Kirk | 2019-01-22 07:35:10 | Tuning threshold for BAS_BULKREAD (large tables) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rangaraj G | 2019-01-22 12:54:06 | RE: Memory and hard ware calculation : |
| Previous Message | Cleiton Luiz Domazak | 2019-01-21 17:43:20 | Re: Memory and hard ware calculation : |