[pgpool-general: 5903] Re: lb_weight not honored?
ishii at sraoss.co.jp
Tue Jan 30 07:56:31 JST 2018
> 0 | host1.prod | 5432 | up | 0.004975 | primary |
> 224368 | false | 0
> 1 | host2.prod | 5432 | up | 0.995025 | standby |
> 451440 | true | 24
> To make an example, I set backend weight to 200 for one node, and 1
> for other node. However, query count is just about 2:1. I expect to
> see much less queries going to host1.prod. Load is low on both nodes.
> Am I doing something wrong here? Thank you.
Pgpool-II internally sends queries to primary PostgreSQL to inspect
their system catalogs regardless the weight parameters. Probably
that's the reason why you see larger query count than expected on
SRA OSS, Inc. Japan
More information about the pgpool-general