Re: [PERFORM] Server stalls, all CPU 100% system time

2013-02-27 Thread Josh Berkus
> Someone commented they think it might be related to this kernel bug: > > https://lkml.org/lkml/2012/10/9/210 > We have some evidence that that is the case. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql

Re: [PERFORM] Server stalls, all CPU 100% system time

2013-02-27 Thread Andre
On 27/02/2013 9:29 AM, Josh Berkus wrote: Andre, Please see the related thread on this list, "High CPU usage / load average after upgrading to Ubuntu 12.04". You may be experiencing some of the same issues. General perspective seems to be that kernels 3.0 through 3.4 have serious performance i

Re: [PERFORM] Server stalls, all CPU 100% system time

2013-02-26 Thread Scott Marlowe
On Tue, Feb 26, 2013 at 4:29 PM, Josh Berkus wrote: > Andre, > > Please see the related thread on this list, "High CPU usage / load > average after upgrading to Ubuntu 12.04". You may be experiencing some > of the same issues. General perspective seems to be that kernels 3.0 > through 3.4 have s

Re: [PERFORM] Server stalls, all CPU 100% system time

2013-02-26 Thread Josh Berkus
Andre, Please see the related thread on this list, "High CPU usage / load average after upgrading to Ubuntu 12.04". You may be experiencing some of the same issues. General perspective seems to be that kernels 3.0 through 3.4 have serious performance issues. -- Josh Berkus PostgreSQL Experts

Re: [PERFORM] Server stalls, all CPU 100% system time

2013-02-26 Thread Andre
On 25/02/2013 12:45 AM, Tom Lane wrote: Odd. I wonder if you are seeing some variant of the old context swap storm problem. The "99.8% system time" reading is suggestive but hardly conclusive. Does top's report of context swap rate go to the moon? It would be interesting to strace a few of the ser

Re: [PERFORM] Server stalls, all CPU 100% system time

2013-02-24 Thread Scott Marlowe
On Sun, Feb 24, 2013 at 7:08 AM, Andre wrote: > Hi, > Since our upgrade of hardware, OS and Postgres we experience server stalls > under certain conditions, during that time (up to 2 minutes) all CPUs show > 100% system time. All Postgres processes show BIND in top. > Usually the server only has a

Re: [PERFORM] Server stalls, all CPU 100% system time

2013-02-24 Thread Tom Lane
Andre writes: > Since our upgrade of hardware, OS and Postgres we experience server stalls > under certain conditions, during that time (up to 2 minutes) all CPUs show > 100% system time. All Postgres processes show BIND in top. Odd. I wonder if you are seeing some variant of the old context s

Re: [PERFORM] Server stalls, all CPU 100% system time

2013-02-24 Thread Andre
On 25/02/2013 12:13 AM, Bèrto ëd Sèra wrote: and your /etc/sysctl.conf is? /etc/sysctl.conf only had unrelated options set, here is the output of sysctl -a: abi.vsyscall32 = 1 debug.exception-trace = 1 dev.hpet.max-user-freq = 64 kernel.acct = 4230 kernel.acpi_video_flags = 0 kernel.

Re: [PERFORM] Server stalls, all CPU 100% system time

2013-02-24 Thread Bèrto ëd Sèra
and your /etc/sysctl.conf is? Cheers Bèrto On 24 February 2013 14:08, Andre wrote: > Hi, > Since our upgrade of hardware, OS and Postgres we experience server stalls > under certain conditions, during that time (up to 2 minutes) all CPUs show > 100% system time. All Postgres processes show BIND