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

[Tatsuo Ishii]

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
Japanese:http://www.sraoss.co.jp

> 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
>>>
>>>
>>