[Pgpool-general] question to loadbalacing

[Uwe Bartels]

Hi,

I'm evaluating pgpool for the load-balancing feature and have some
problems with the load distribution.

I created 3 servers as configured in pgpool below. The healthcheck tells
me all 3 are in state 1 (hope this means ok.)
I can connect via pgpool and run sql, I can connect to all single
servers and run sql. All 4 componets running on the same machine.

max_pool = 1
replication_mode = false
load_balance_mode = true
replicate_select = false
master_slave_mode = true
parallel_mode = false
backend_hostname0 = 'localhost'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/test_db'
backend_hostname1 = 'localhost'
backend_port1 = 5433
backend_weight1 = 1
backend_data_directory1 = '/test_db_slave'
backend_hostname2 = 'localhost'
backend_port2 = 5434
backend_weight2 = 1
backend_data_directory2 = '/test_db_slave1'


When I run pgbench all selects are sent to one server not to all.

-bash-3.00$ egrep -ci "duration.*select" /test_db*/pg_log/*
/test_db/pg_log/postgresql-2008-06-30_122823.log:0
/test_db_slave/pg_log/postgresql-2008-06-30_122823.log:0
/test_db_slave1/pg_log/postgresql-2008-06-30_122823.log:2854
-
bash-3.00$ pgbench -h localhost -p 9999 -t 10 -U pgbench -P pgbench -N
-S -c 95 -n pgbench
transaction type: SELECT only
scaling factor: 1
number of clients: 95
number of transactions per client: 10
number of transactions actually processed: 950/950
tps = 367.932548 (including connections establishing)
tps = 611.073553 (excluding connections establishing)

-bash-3.00$ egrep -ci "duration.*select" /test_db*/pg_log/*
/test_db/pg_log/postgresql-2008-06-30_122823.log:0
/test_db_slave/pg_log/postgresql-2008-06-30_122823.log:0
/test_db_slave1/pg_log/postgresql-2008-06-30_122823.log:3805

Where is the error?

Second thing which is unclear to me, is how do I use Loadbalancing
without connection pooling? Is it possible at all? When setting
max_pool=0 pgpool complains about shared_memory. So I set  it to 1.

I'm using pgpool-II 2.0.1 and latest release: pgpool-II-2.1-beta2


Uwe