[pgpool-general: 2434] Re: pgpool connections: FATAL: sorry, too many clients already

Sergey Arlashin sergeyarl.maillist at gmail.com
Thu Jan 16 15:23:48 JST 2014


On Jan 16, 2014, at 10:10 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:

>> It seems I misunderstood this formula :) 
>> 
>> I have 2 backends. Each can handle 27 connections. So I want pgpool to be able to handle 27*2 connections. 
>> 
>> 
>> If I use 
>> 
>> 13 * 2 <= (30 -3 ) 
>> 
>> then the total number of connections won't exceed 26. Is that correct? 
> 
> Yes, correct.
> 

So this where this calculation comes from. 
I mean: 25*2 <= (30-3)*2

If I use 13*2 <= (30-3) then there will be no way to utilize the capacity of all backend servers. Is that so? 


> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp



More information about the pgpool-general mailing list