[pgpool-general: 5900] lb_weight not honored?

Boris boris at splet.net
Sun Jan 28 17:34:56 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.


More information about the pgpool-general mailing list