Re: Further info : Very high load average but no cpu utilization - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Further info : Very high load average but no cpu utilization
Date
Msg-id 200206051633.g55GXm718101@candle.pha.pa.us
Whole thread Raw
In response to Re: Further info : Very high load average but no cpu utilization ?  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Responses Re: PostgreSQL on AIX  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List pgsql-sql
D'Arcy J.M. Cain wrote:
> On May 13, 2002 12:50 am, Rajesh Kumar Mallah. wrote:
> > Its advocated "dont kill -9 the postmaster" and i rarely do that.
> 
> Advocated or not, kill -9 is supposed to be the last resort.  If nothing else 
> works then kill -9 should kill any Unix process.  As Tom says, if it doesn't 
> then it suggests an OS (probably driver) problem.
> 
> Now if only I could get IBM to understand that.  They still claim that my 
> problem is that PostgreSQL (an "unsupported" application) is doing something 
> to catch SIGKILL.

First, an application can't catch SIGKILL. It never arrives to
applications.  It is supposed to pull the process with no warning.

However, there are things processes can do to wedge themselves in a
system call so they don't see the SIGKILL.  Of course, as soon as they
return from the system call, they die.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: James Orr
Date:
Subject: Re: Is this a feature ?
Next
From: Josh Berkus
Date:
Subject: Indexing Metaphone?