[pgpool-general: 1538] Re: Mysterious Load Spikes

Will Ferguson wferguson at northplains.com
Thu Mar 28 18:27:54 JST 2013

Have a look in the postgres performance mailing lists. There's been a 
lot of chatter recently about performance problems regarding 3.x kernels.


On 27/03/13 15:24, Quentin Hartman wrote:
> On Wed, Mar 27, 2013 at 9:15 AM, Lonni J Friedman <netllama at gmail.com 
> <mailto:netllama at gmail.com>> wrote:
>     FWIW, I also see roughly the same behavior, although my environment is
>     somewhat different than yours.  Previously my pgpool server was
>     running on RHEL6, however it was migrated to Fedora17 (without
>     changing the pgpool version).  Before the migration the load on the
>     server was typically less than 1.00.  Since migrating the load average
>     is 30+ (with spikes up to 60 quite often).  Yet there's nothing
>     obvious causing the load.  I'm certain something in pgpool is causing
>     this behavior, because the load drops to 0 during the rare times when
>     we need to stop pgpool for maintenance.
> 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.
> If anyone else is interested in coordinating efforts, I'd be glad for 
> the help.
> QH
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general

*Will Ferguson*
Technical Operations Manager
Zetland House, 5-25 Scrutton Street
London, EC2A 4HJ, UK
p: +44 (0)207 749 1800
e: wferguson at northplains.com <mailto:wferguson at northplains.com>
w: www.northplains.com <http://www.northplains.com/>
Blog: http://www.northplains.com/blog/ <http://www.northplains.com/blog>
Twitter: https://twitter.com/northplains
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130328/9a8175f2/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: email-signaturelogosmaller.png
Type: image/png
Size: 6214 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130328/9a8175f2/attachment.png>

More information about the pgpool-general mailing list