I haven't had a chance to look at those threads yet, but would postgres performance be relevant to pgpool performance? Do they use similar kernel features? My pgpool boxes are only running pgpool, postgres is running on different machines entirely.<br>
<br>For what it's worth, our postgres boxes are showing slightly _lower_ overall load after the upgrade. We went from 9.1.x running on Ubuntu 11.04 to 9.2.3 running on Ubuntu 12.04. Just eyeballing the graphs it looks about 5-ish% less measured 1-minute LA, but we're servicing the same number of requests.<br>
<br><div class="gmail_quote">On Thu, Mar 28, 2013 at 8:41 AM, Lonni J Friedman <span dir="ltr"><<a href="mailto:netllama@gmail.com" target="_blank">netllama@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Did you have a particular thread in mind? I scanned the list<br>
archives, and honestly didn't see anything relevant. The closest<br>
thing was this very recent off-topic post:<br>
<a href="http://www.postgresql.org/message-id/51519CE9.1070409@opinioni.net" target="_blank">http://www.postgresql.org/message-id/51519CE9.1070409@opinioni.net</a><br>
<div><div class="h5"><br>
On Thu, Mar 28, 2013 at 2:27 AM, Will Ferguson<br>
<<a href="mailto:wferguson@northplains.com">wferguson@northplains.com</a>> wrote:<br>
><br>
> Have a look in the postgres performance mailing lists. There's been a lot of chatter recently about performance problems regarding 3.x kernels.<br>
><br>
> Will<br>
><br>
><br>
> On 27/03/13 15:24, Quentin Hartman wrote:<br>
><br>
> On Wed, Mar 27, 2013 at 9:15 AM, Lonni J Friedman <<a href="mailto:netllama@gmail.com">netllama@gmail.com</a>> wrote:<br>
>><br>
>> FWIW, I also see roughly the same behavior, although my environment is<br>
>> somewhat different than yours. Previously my pgpool server was<br>
>> running on RHEL6, however it was migrated to Fedora17 (without<br>
>> changing the pgpool version). Before the migration the load on the<br>
>> server was typically less than 1.00. Since migrating the load average<br>
>> is 30+ (with spikes up to 60 quite often). Yet there's nothing<br>
>> obvious causing the load. I'm certain something in pgpool is causing<br>
>> this behavior, because the load drops to 0 during the rare times when<br>
>> we need to stop pgpool for maintenance.<br>
><br>
><br>
> Thanks for the quick reply Lonni. I'm glad to hear that it's not a problem limited to Ubuntu. Like you I suspect it has something to do with the 3.x kernel series. I'm going to be doing some experimentation soon to try to isolate and eliminate this problem. I'll update this thread with my findings.<br>
><br>
> If anyone else is interested in coordinating efforts, I'd be glad for the help.<br>
><br>
> QH<br>
><br>
><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>
><br>
> --<br>
> Will Ferguson<br>
> Technical Operations Manager<br>
> Zetland House, 5-25 Scrutton Street<br>
> London, EC2A 4HJ, UK<br>
> p: <a href="tel:%2B44%20%280%29207%20749%201800" value="+442077491800">+44 (0)207 749 1800</a><br>
> e: <a href="mailto:wferguson@northplains.com">wferguson@northplains.com</a><br>
> w: <a href="http://www.northplains.com" target="_blank">www.northplains.com</a><br>
> Blog: <a href="http://www.northplains.com/blog/" target="_blank">http://www.northplains.com/blog/</a><br>
> Twitter: <a href="https://twitter.com/northplains" target="_blank">https://twitter.com/northplains</a><br>
><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>
<br>
<br>
<br>
--<br>
</div></div>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>
L. Friedman <a href="mailto:netllama@gmail.com">netllama@gmail.com</a><br>
LlamaLand <a href="https://netllama.linux-sxs.org" target="_blank">https://netllama.linux-sxs.org</a><br>
</blockquote></div><br>