Hi, From: Uwe Bartels <[EMAIL PROTECTED]> Subject: [Pgpool-general] question to loadbalacing Date: Mon, 30 Jun 2008 14:33:21 +0200
> 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 Are you setting log_duration on test_db and test_db_slave? test_db_slave1 has 2854 lines. However, the total number of transactions is 950. If pgpool sends to one server, the number of a log is 950 * N. > number of transactions actually processed: 950/950 > 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. You need to set connection_cache to false in pgpool.conf. Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
