<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">If I understand your question
correctly you want to balance functions in the schema
stored_functions_v0. I believe the only way is to list all of the
functions, but you can use regex pattern matching to make life
easier. For example, if all those functions have "_v0" at the end
of the name you could do something like this:<br>
<br>
white_function_list = '.*_v0'<br>
black_function_list = '.*'<br>
<br>
To see the load balancing happen you'll have to turn on query
logging on the backends and watch the postgres logs. Remember,
the load balancing is by connection rather than by query so you'll
have to disconnect and reconnect each time to see the queries
distribute across both backends.<br>
<br>
<br>
alex<br>
<br>
<br>
On 3/31/15 7:27, Mephysto wrote:<br>
</div>
<blockquote
cite="mid:CAG0sfBUT9so2ZFDSLGYFfiRsq7jGh=c1Ytuv8kK1k6+C4WDy=w@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_default"
style="font-family:verdana,sans-serif">Hi there,</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">I'm using Postgres 9.4
and pgpool-II 3.4 in Master-Slave configuration and streaming
replication between nodes (two at the moment).</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">In my database I'm
using a schema only for stored_functions, its name il
stored_functions_v0. I need some example to coonfigure
white_function_list parameter in pgpool.conf in order to
balance readonly stored functions beetween my nodes.</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">Can someone provide me
these examples?</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">In case of load
balancing of stored functions is feasible, how can I check if
load balancing work done?</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">Thanks in advance.</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">Kind regards.</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">Meph</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
<br>
</body>
</html>