Skip site navigation (1) Skip section navigation (2)

Re: Server hitting 100% CPU usage, system comes to a crawl.

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Brian Fehrle <brianf(at)consistentstate(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Server hitting 100% CPU usage, system comes to a crawl.
Date: 2011-10-27 19:52:07
Message-ID: CAOR=d=34gXGJdQsAFNBi5Fz67TmrvYtt=aLAN6CPPgeFqYsuxw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On Thu, Oct 27, 2011 at 1:48 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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.

In response to

Responses

pgsql-general by date

Next:From: Scott MarloweDate: 2011-10-27 19:54:29
Subject: Re: Server hitting 100% CPU usage, system comes to a crawl.
Previous:From: Scott MarloweDate: 2011-10-27 19:48:09
Subject: Re: Server hitting 100% CPU usage, system comes to a crawl.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group