[Pgpool-general] question to loadbalacing

[Yoshiyuki Asaba]

Hi,

From: Uwe Bartels <uwe.bartels at gmail.com>
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
y-asaba at sraoss.co.jp