[Pgpool-general] pgpool-II load balancing

[Tatsuo Ishii]

I got a personal mail regarding pgpool-II 3.0.3 load
balancing(replication mode). To share info among community, I post
this.

>> I may have to throw away pgool-II, unfortunately. Here is my story -
>> http://mwrynn.blogspot.com/2011/05/pgpool-ii-load-balancing.html - do
>> you have any advice on what I might be doing wrong?

I have tested 3.0.3 by using pgbench and see no problem.

1. Make sure that pgpool-II write logs to somewhere. For example:

pgpool -n ... >&/tmp/pgpool.log&

Please note that "-n" is mandatory.

2. Run pgbench to issue trivial SELECTs via pgpool-II.

pgbench -p 9999 -n -S -C -c 2 -t 1000 test

3. Grep pgpool log to find how many SELECTs being sent to each PostgreSQL.

grep SELECT /tmp/pgpool.log|grep "node id: 0"|wc		# number of queries sent to DB 0
grep SELECT /tmp/pgpool.log|grep "node id: 1"|wc		# number of queries sent to DB 1

I see almost same number of quries being sent to each node.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp