Re: Server stalls, all CPU 100% system time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andre <pg(at)darix(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Server stalls, all CPU 100% system time
Date: 2013-02-24 14:45:59
Message-ID: 15088.1361717159@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Andre <pg(at)darix(dot)de> 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 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 server processes while
one of these events is happening, too.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2013-02-24 16:43:35 Re: Server stalls, all CPU 100% system time
Previous Message Andre 2013-02-24 14:39:34 Re: Server stalls, all CPU 100% system time