[pgpool-general: 2212] Re: Pgpool2 3.3.0: idle connections

[Sergey Arlashin]

I disabled connection_cache and now the number of idle connections on pgpool server and the number of idle connections on backends are equal.

The only thing I found about connection_cache in documentation is 

connection_cache
Caches connections to backends when set to true. Default is true. You need to restart pgpool-II if you change this value.

So I think now the question is - what is connection_cache ?  

On Oct 23, 2013, at 11:33 AM, Sergey Arlashin <sergeyarl.maillist at gmail.com> wrote:

> Hi! 
> 
> I have the following setup: 1 pgpool2 server with 2 postgresql 9.2 backends with streaming replication.
> 
> Recently I've noticed a strange thing - the number of idle pgpool connections on pgpool2 server is very low. Like 
> # ps uax |grep -i pgpool | grep -i idle | wc -l
> 1
> 
> And the number of idle postgresql connections on backends is much higher 
> 1st-backend# ps uax |grep -i postgres |grep -i idle | wc -l
> 46
> 
> 2nd-backend# ps uax |grep -i postgres |grep -i idle | wc -l
> 47
> 
> Also I see a lot of tcp ESTABLISHED connections from pgpool server to postgresql backends.  
> 
> 
> Could you please explain this behaviour?
> 
> Thanks in advance
> 
> --
> Sergey Arlashin
> 
> 
>