[pgpool-general: 5292] Re: Connections to backends

[Tatsuo Ishii]

> Hello.
> 
> I have a following configuration:
> 
> 3 backends with replication in master-slave mode.
> 2 pgpools with delegate_IP and watchdog, with weights of backends as
> following:
> master = 1
> both slaves = 0
> 
> My understanding is that pgpool shouldnt make requests to backend nodes with weight of 0.
>
> The question is why does pgpool establishes a connections to those nodes?

Ideally in your case Pgpool-II only needs to connect to the master
only. It's already on our TODO list.

> Second question, something i couldn't understand from reading a documentation: why does number of connections to backends is much more than number of connections to frontend?

http://pgpool.net/mediawiki/index.php/FAQ#Why_max_connection_must_satisfy_this_formula_max_connection_.3E.3D_.28num_init_children_.2A_max_pool.29_and_not_max_connection_.3E.3D_num_init_children.3F

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