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

[Josh Berkus]

All,

I have two servers which are being replicated by Slony-I.  I intend to
use pgpool2 to do load-balancing between them.  The client application
will request up to 600 connections, most of which are idle most of the
time, but most of which are fairly long-lived even if they spend hours
idle.  95% of connections are the same user/database.

Given this, how should I configure:
num_init_children

max_pool


child_max_connections
... and more importantly, why?

Also, the instructions on master/slave mode have this bit of information:

DB nodes' information must be set as the replication mode.

... but where or how to set that isn't explained.  Please explain?

Thanks!

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