Re: Server stalls, all CPU 100% system time

On Sun, Feb 24, 2013 at 7:08 AM, Andre <pg(at)darix(dot)de> 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 load of < 0.5 (12 cores) with up to 30
> connections, 200-400 tps
>
> Here is top -H during the stall:
> Threads: 279 total, 25 running, 254 sleeping, 0 stopped, 0 zombie
> %Cpu(s): 0.2 us, 99.8 sy, 0.0 ni, 0.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0
> st

It might be useful to see a page of top output as well. Further turn
on sysstat data collection so you do some post mortem work.