Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id E82B79F9DAD for ; Thu, 16 Nov 2006 14:26:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 34329-01-7 for ; Thu, 16 Nov 2006 14:26:04 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 2F6AF9FA004 for ; Thu, 16 Nov 2006 14:25:26 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by svr4.postgresql.org (Postfix) with ESMTP id B875E5AFBFC for ; Thu, 16 Nov 2006 15:07:37 +0000 (GMT) Received: by ug-out-1314.google.com with SMTP id k3so386099ugf for ; Thu, 16 Nov 2006 07:06:36 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=f7UU2BORwiZ9WazDgHKFo+Vq61fLTRM8bKwX6ksuGKy67+yDk68HrbCJZd+ZxTrPDc4up1po1otiem8ELbT0VYta69gvgVduKR8RdhKRhUNTAgaNKx3LuR9iylFaAeRZGZtYWn/oBxuG9my2hdy3a5MR+Elk36TYRpDCQ0AzxY4= Received: by 10.78.157.8 with SMTP id f8mr570760hue.1163685688472; Thu, 16 Nov 2006 06:01:28 -0800 (PST) Received: by 10.78.45.3 with HTTP; Thu, 16 Nov 2006 06:01:28 -0800 (PST) Message-ID: Date: Thu, 16 Nov 2006 09:01:28 -0500 From: "Merlin Moncure" To: "Craig A. James" Subject: Re: Postgres server crash Cc: pgsql-performance@postgresql.org In-Reply-To: <455BCAE8.8010905@modgraph-usa.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20061023215913.GW26892@nasby.net> <20061025001709.GA26892@nasby.net> <453EF7C4.2040105@modgraph-usa.com> <455BCAE8.8010905@modgraph-usa.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/128 X-Sequence-Number: 21898 On 11/15/06, Craig A. James wrote: > Questions: > 1. Any idea what happened and how I can avoid this? It's a *big* problem. > 2. Why didn't the database recover? Why are there two processes > that couldn't be killed? > 3. Where did the "signal 9" come from? (Nobody but me ever logs > in to the server machine.) how much memory is in the box? maybe vmstat will give you some clues about what is going on leading up to the crash...a spike in swap for example. Maybe, if you can budget for it, query logging might give some clues also. Try increasing swap. merlin