[Pgpool-general] understanding backend_weight

[Tomasz Chmielewski]

Tomasz Chmielewski wrote:

> Thanks.
> Out of curiosity, how would be such values handled?

I made some typos wrt numbers -once again, corrected below:

backend_hostname0 = 'postgres1'
backend_weight0 = 0

backend_hostname1 = 'postgres2'
backend_weight1 = 1

backend_hostname1 = 'postgres3'
backend_weight2 = 2


postgres1 should not get any reads.
postgres2 should get 33,3(3)% reads.
postgres3 should get 66,6(6)% reads.

?


-- 
Tomasz Chmielewski
http://wpkg.org