[pgpool-general: 5051] Re: PGPool - Load Balancing - Query or connection level

Tatsuo Ishii ishii at sraoss.co.jp
Mon Oct 17 21:45:41 JST 2016


> Hi I have setup PGPool with Load Balancing enabled. I notice that the Load Balancing is done at the connection level - not at the query level. ie: only new connections are LB, where as an open connection in PGAdmin for example and run multiple selects statements in PGSQLAdmin window are run against same node ie: Master.
> 
> So, first of all how does the PGPool LB work - connection (ie: each connection/query will be LB across server or query level?
> 
> Can I specify one or the other.

Pgpool-II's load balancing is connection level. Once a session from
client to Pgpool-II is established, the load balancing target server
will not be changed until the session ends.

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