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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
