[Pgpool-general] Setting up connections config for load-balancing

Josh Berkus josh at agliodbs.com
Fri Aug 13 00:37:23 UTC 2010


> No. I suspect bogus pgpool_status file is remained. Try:
> 
> Shudtown pgpool
> Remove pgpool_status
> Start pgpool

That appears to be the case.  Is pgPool supposed to remove pgpool_status
when it shuts down?

> This is normal. The value you see is the normalized value. From the
> comment in pool_config.l:
> 
> 	/*
> 	 * Normalize load balacing weights. What we are doing here is,
> 	 * assign 0 to RAND_MAX to each backend's weight according to the
> 	 * value weightN.  For example, if two backends are assigned 1.0,
> 	 * then each backend will get RAND_MAX/2 normalized weight.
> 	 */

Hmmm.  You might want to display a more user-friendly value for the
user, though, no?


-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com


More information about the Pgpool-general mailing list