[pgpool-general: 6465] Re: Load balancing and unused status

Tatsuo Ishii ishii at sraoss.co.jp
Mon Mar 18 09:18:31 JST 2019

> Thanks, now the standby is up.
> But I'm not sure if I understand the balancing rules.
> What I would like is for the consultations to be divided more evenly.
> I tried to test the load balancing by opening several psql's on my local
> machine and doing queries on each of them, but it looks like the queries
> are always being routed to the standby now ...
> The docs says:
> To which node the load balancing mechanism sends read queries is decided at
> the session start time and will not be changed until the session ends.
> Does this mean that every query will be directed to the same node, until
> there is a write operation, on connection basis?

Connection basis.

If you want to know how write operations affect the load balancing of
Read operations, please check doc of disable_load_balance_on_write.

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

More information about the pgpool-general mailing list