Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id BDC62475C29 for ; Mon, 13 May 2002 00:51:29 -0400 (EDT) Received: from mail-relay.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 12A01475D88 for ; Mon, 13 May 2002 00:50:33 -0400 (EDT) Received: (qmail 1463 invoked from network); 13 May 2002 04:44:33 -0000 Received: from system29.trade-india-local.com (HELO server) (192.168.0.29) by ptil-236-129-del.primus-india.net with SMTP; 13 May 2002 04:44:33 -0000 Content-Type: text/plain; charset="iso-8859-1" From: "Rajesh Kumar Mallah." Organization: Infocom Network Limited. To: Tom Lane , pgsql-sql@postgresql.org Subject: Re: Further info : Very high load average but no cpu utilization ? Date: Mon, 13 May 2002 10:20:07 +0530 X-Mailer: KMail [version 1.4] References: <200205111007.47338.mallah@trade-india.com> <20020512110537.F403E1BBC@druid.net> <29864.1021217871@sss.pgh.pa.us> In-Reply-To: <29864.1021217871@sss.pgh.pa.us> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200205131020.07302.mallah@trade-india.com> X-Archive-Number: 200205/115 X-Sequence-Number: 7751 Well, Its advocated "dont kill -9 the postmaster" and i rarely do that. Postmaster tends to be immortal , And it is *not* so only for the case when postmaster is trying to write past 2GB limit , I have only recently started logging postmaster to that extent. regds mallah. On Sunday 12 May 2002 09:07 pm, Tom Lane wrote: > "D'Arcy J.M. Cain" writes: > > Not even kill -9 worked? I had that happen too but I thought it was a > > problem with AIX. Kill -9 is supposed to kill any process. It can't be > > caught. Is it possible that PostgreSQL is doing something that makes it > > that unkillable? > > Could there be a kernel bug associated with processes that are trying to > write past the 2Gb limit? The postmaster is certainly not doing > anything deliberate to make itself unkillable, but on some platforms > kill -9 will not work on processes that are wedged in a system call... > > regards, tom lane --=20 Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.