[pgpool-general: 7268] Re: Question about load-balancing
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
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
More information about the pgpool-general