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

Tatsuo Ishii ishii at sraoss.co.jp
Tue Dec 13 16:25:06 JST 2016

You can monitor load balancing by enabling log_per_node_statement.

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

> Hi Cepren,
> I did it, but I'm not sure I did it correctly. For this reason I need a way
> to monitor load balancing.
> Regards.
> Meph
> On 13 Dec 2016 8:05 a.m., "Сергей Мелехин" <cpro29a at gmail.com> wrote:
>> 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

More information about the pgpool-general mailing list