Re: Memory and hard ware calculation : - Mailing list pgsql-performance

From Fabio Pardi
Subject Re: Memory and hard ware calculation :
Date
Msg-id db537968-f959-7b14-3264-8a705c0bf422@portavita.eu
Whole thread Raw
List 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
> 
>  
> 


pgsql-performance by date:

Previous
From: Luis Carril
Date:
Subject: Re: JIT overhead slowdown
Next
From: Mickael van der Beek
Date:
Subject: Very long query planning times for database with lots of partitions