[pgpool-general: 7268] Re: Question about load-balancing

Bo Peng pengbo at sraoss.co.jp
Thu Sep 10 14:32:01 JST 2020


> I’d like to know the way Pgpool dispatches read-only queries. For instance, when set 
> “synchronous_standby_names” to be “any 2 (node0, node1, node2)” on primary Postgresql server and if
> “node0” and “node1” are sync nodes, will the read-only query will be sent to “node2”?  

Yes. The node2 may be elected as a load balancing node.
Pgpool does not consider if it is a sync node.

> Or are there some configurations to control this? 

No. So far there are no such parameters yet.

On Tue, 8 Sep 2020 03:46:48 +0000
"Xiao Lei Jia1" <Xiao.Lei.Jia1 at ibm.com> wrote:

> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general

Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan

More information about the pgpool-general mailing list