Re: Server hitting 100% CPU usage, system comes to a crawl. - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Server hitting 100% CPU usage, system comes to a crawl.
Date
Msg-id CAOR=d=34gXGJdQsAFNBi5Fz67TmrvYtt=aLAN6CPPgeFqYsuxw@mail.gmail.com
Whole thread Raw
In response to Re: Server hitting 100% CPU usage, system comes to a crawl.  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Server hitting 100% CPU usage, system comes to a crawl.  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
On Thu, Oct 27, 2011 at 1:48 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> OK, a few points.  1: You've got a zombie process.  Find out what's

To expand on the zombie thing, it's quite possible that you're
managing to make a pg backend process crashout, which would cause the
db to restart midday, which is bad (TM) since that dumps all of shared
buffers and forces all clients to reconnect.  So look through the
system logs for segmentation faults, etc.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Server hitting 100% CPU usage, system comes to a crawl.
Next
From: Scott Marlowe
Date:
Subject: Re: Server hitting 100% CPU usage, system comes to a crawl.