[Pgpool-general] pgpool-II load balancing

[Lazaro Rubén García Martinez]

I read the post send by you in the email shown below, but I have a doubt. The number for backend_wheight is a number between 0 and 1?.
Is this a probabilistic number?

Regards.
________________________________________
De: pgpool-general-bounces at pgfoundry.org [pgpool-general-bounces at pgfoundry.org] En nombre de Tatsuo Ishii [ishii at sraoss.co.jp]
Enviado el: viernes, 06 de mayo de 2011 18:45
Para: pgpool-general at pgfoundry.org
Asunto: [Pgpool-general] pgpool-II load balancing

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