[Pgpool-general] Help in pgpool loadbalancing

Glyn Astill glynastill at yahoo.co.uk
Sun Jul 19 18:29:42 UTC 2009


> From: Nimesh Satam <nimesh.satam at gmail.com>
> Subject: [Pgpool-general] Help in pgpool loadbalancing
> To: pgpool-general at pgfoundry.org
> Date: Sunday, 19 July, 2009, 4:04 PM
> Hi,
>  
> Can anybody highlight how queries can be loadbalanced
> in pgpool? How does backend_weight0 means and what happens
> if the value for this parameter is set to '0'.
>  
> I need to use this parameter in the given below way:
> 
>  
> Set backend_weight0 = 0 
>  
> So as no queries go to the first node. But in our
> usage we do see queries coming to the node for whom the
> parameter is set to 0. We are using pgpool in master/slave
> mode, with no connection caching.
>  
> 

If you do not want any queries to go through to the first node, why not just remove it completely from the config?


      


More information about the Pgpool-general mailing list