[Pgpool-general] understanding backend_weight

Tomasz Chmielewski mangoo at wpkg.org
Mon Nov 16 13:16:37 UTC 2009


How should I understand "backend_weight" config variable?

For example, I have two postgres servers: "local" and "remote".

I would like to execute all SELECT operations on the "local" server only 
/ mostly.


What backend_weight should I use?

backend_hostname0 = 'local'
backend_weight0 = 0

backend_hostname1 = 'remote'
backend_weight1 = 1


Or maybe:


backend_hostname0 = 'local'
backend_weight0 = 1

backend_hostname1 = 'remote'
backend_weight1 = 0


Or is the meaning of backend_weight totally different?


-- 
Tomasz Chmielewski
http://wpkg.org


More information about the Pgpool-general mailing list