<div dir="ltr"><div>Hi!</div>You can SELECT * FROM <function name> with set returning functions too, and it will be load balanced.</div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature">С Уважением, Сергей Мелехин.</div></div>
<br><div class="gmail_quote">2015-04-01 17:36 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="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif">Thank you Alex, thank you Сергей, I will do some tests today.</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif">I have another question for you: can I call stored functions by SELECT * <function name> or is the only way to have balancing calling stored function by SELECT <function name>?</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif">Bye.</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><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On 1 April 2015 at 08:48, Сергей Мелехин <span dir="ltr"><<a href="mailto:cpro29a@gmail.com" target="_blank">cpro29a@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi!<div>We are using this feature. Pgpool does not support schema specification in white/black lists so beware!</div><div>The easiest way is to write comma separated list of your readonly functions. Only names, without schemas!</div><div>Here's my settings:</div><div><br></div><div><div>white_function_list = 'parse_vac_query,get.*,rated_search'</div><div>black_function_list = ''</div></div><div><br></div><div>all functions starting with "get" and parse_vac_query and rated_search are been balanced between master and slave. All other stored procedures execute on master only.</div></div><div class="gmail_extra"><br clear="all"><div><div>С Уважением, Сергей Мелехин.</div></div><div><div>
<br><div class="gmail_quote">2015-04-01 6:10 GMT+10:00 Alex Toth <span dir="ltr"><<a href="mailto:atoth@gravity.com" target="_blank">atoth@gravity.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>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<div><div><br>
<br>
<br>
On 3/31/15 7:27, Mephysto wrote:<br>
</div></div></div>
<blockquote type="cite"><div><div>
<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></fieldset>
<br>
</div></div><pre>_______________________________________________
pgpool-general mailing list
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
<br>
</div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div></div></div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>