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

[Mephysto On Hell]

I'll try it.

Thank you very much Tatsuo.



On 13 Dec 2016 8:25 a.m., "Tatsuo Ishii" <ishii at sraoss.co.jp> wrote:

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