[pgpool-general: 5168] Re: pgpool and jdbc pool

[Сергей Мелехин]

Hi!
By default, pgpool treats all stored functions as potentially data
modifying. So it sends them to master.
If you know your function never modifies the data, you should add its name
to white_function_list parameter in pgpool config.

С Уважением, Сергей Мелехин.

2016-12-13 16:49 GMT+10:00 Mephysto <mephystoonhell at gmail.com>:

> 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
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161213/7ab86694/attachment.html>