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

Mephysto On Hell mephystoonhell at gmail.com
Tue Dec 13 16:08:43 JST 2016


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
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161213/c912dc3e/attachment-0001.html>


More information about the pgpool-general mailing list