<div dir="ltr"><div class="gmail_default" style="font-family:arial narrow,sans-serif;font-size:x-small">It would likely be far more useful if you provided details about your environment. You didn't even say what version of pgpool or postgres you were using, or how any one else could replicate the problem you reported. What does your pgpool.conf look like? What kind of hardware? Which OS?<br>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jul 22, 2013 at 7:17 AM, KaBaSZo <span dir="ltr"><<a href="mailto:tobix10@gmail.com" target="_blank">tobix10@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"><div class="gmail_default" style="font-family:verdana,sans-serif"><table><tbody><tr><td><div>
<span></span><br>
</div>
</td>
<td>
<div>
<div>
<p>I have a problem with pgpool II configured in master-slave
mode with replication on slony.
I have configured postgres databases on each server to run as fast as
they can and this was verified by me when I set up connection directly
to the db server. However when connection is established by pgpool sth
goes wrong, my webapp on tomcat starts very slowly(30min in compare to
5min without pgpool).</p>
<p>I can't figure out what is wrong. On working webapp communication is a
bit slower, but difference is so much smaller than at startup.</p>
<p>PGPool use ssh tunnels to communicate with servers. </p>
<p>I've read sth about pgpool and if I understood correctly number of
connections(pools) is determine by tuples(database, user). I use only
one database and user, is that a reason? If so is there anything I can
do to speed up pgpool?</p>
<p>Thanks in advance.</p>
</div></div></td></tr></tbody></table></div></div>
<br>_______________________________________________<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" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>L. Friedman <a href="mailto:netllama@gmail.com">netllama@gmail.com</a><br>
LlamaLand <a href="https://netllama.linux-sxs.org">https://netllama.linux-sxs.org</a>
</div>