[pgpool-general: 5167] pgpool and jdbc pool

[Mephysto]

Hi there,
I'm using pgpool to pooling connections for my Postgres cluster, and I'm
using a jdbc pooling in a Glassfish application server to connect a web
application to Postgres.

At the moment I have a strange behaviour for load balancing: I have two pg
nodes, a master and a slave, with the same weight, but queries are executed
almost exclusively to master. I'm using almost only stored functions and no
simple select queries. I tried to set up some filters to send queries to
slave.

It's there a way to monitor how pgpool drive the queries?

Is a good idea to use a jdbc pool to connect applications to pgpool?

Thanks in advance.

Meph
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161213/8af0002b/attachment.html>