Re: Memory and hard ware calculation :

От: Fabio Pardi
Тема: Re: Memory and hard ware calculation :
Дата: ,
Msg-id: db537968-f959-7b14-3264-8a705c0bf422@portavita.eu
(см: обсуждение, исходный текст)
Список: 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 по дате сообщения:

От: Steven Winfield
Дата:
Сообщение: RE: Very long query planning times for database with lots ofpartitions
От: Mickael van der Beek
Дата:
Сообщение: Re: Very long query planning times for database with lots of partitions