[pgpool-general: 5903] Re: lb_weight not honored?

[Tatsuo Ishii]

>  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
host1.

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