<div dir="ltr"><div>Hi!</div>By default, pgpool treats all stored functions as potentially data modifying. So it sends them to master.<div>If you know your function never modifies the data, you should add its name to <span style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;font-size:12px;font-weight:bold">white_function_list</span> parameter in pgpool config.</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature">С Уважением, Сергей Мелехин.</div></div>
<br><div class="gmail_quote">2016-12-13 16:49 GMT+10:00 Mephysto <span dir="ltr"><<a href="mailto:mephystoonhell@gmail.com" target="_blank">mephystoonhell@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto">Hi there,<div dir="auto">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.</div><div dir="auto"><br></div><div dir="auto">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.</div><div dir="auto"><br></div><div dir="auto">It's there a way to monitor how pgpool drive the queries?</div><div dir="auto"><br></div><div dir="auto">Is a good idea to use a jdbc pool to connect applications to pgpool?</div><div dir="auto"><br></div><div dir="auto">Thanks in advance.</div><div dir="auto"><br></div><div dir="auto">Meph</div></div>
<br>______________________________<wbr>_________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>