Re: pl/pgsql performance

On Fri, Apr 25, 2014 at 5:53 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> 2014-04-25 10:48 GMT+02:00 Mehdi Ravanbakhsh <babakco@gmail.com>:
>> 2- how i can chose max connection number for pgsql server based on cpu
>> core and RAM capacity that have maximum Efficiency?
> usually max performance is about 10 x CPU connections. But it highly depends
> on load.
As well as transaction model counts, are you for example using long or
short transactions?
As a starting point, you could as well use something like ((core_count
* 2) + effective_spindle_count). have a look here for more details:
http://wiki.postgresql.org/wiki/Number_Of_Database_Connections#How_to_Find_the_Optimal_Database_Connection_Pool_Size
--
Michael