X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 28B079DCB86 for ; Fri, 24 Mar 2006 06:25:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73153-02 for ; Fri, 24 Mar 2006 06:25:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id D38379DCBD6 for ; Fri, 24 Mar 2006 06:25:18 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id CDBAE56431; Fri, 24 Mar 2006 04:25:20 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Fri, 24 Mar 2006 04:25:20 -0600 Date: Fri, 24 Mar 2006 04:25:20 -0600 From: "Jim C. Nasby" To: Bendik Rognlien Johansen Cc: pgsql-performance@postgresql.org Subject: Re: Problem with query, server totally unresponsive Message-ID: <20060324102520.GS90527@pervasive.com> References: <0B8E0D23-F08D-457D-B26F-1D475F8064F4@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <0B8E0D23-F08D-457D-B26F-1D475F8064F4@gmail.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060324:bendik.johansen@gmail.com::0mpzCp7Chr0/IMea:000000000000 0000000000000000000000003nu0 X-Hashcash: 1:20:060324:pgsql-performance@postgresql.org::TVjVTIFK12heV5t5:00000 0000000000000000000000000J2y X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.108 required=5 tests=[AWL=0.108] X-Spam-Score: 0.108 X-Spam-Level: X-Archive-Number: 200603/485 X-Sequence-Number: 17922 On Thu, Mar 23, 2006 at 01:12:08PM +0100, Bendik Rognlien Johansen wrote: > Hello, I have a big problem with one of my databases. When i run my > query, after a few minutes, the postmaster shows 99% mem i top, and > the server becomes totally unresponsive. You've got a bunch of sorts going on; could you be pushing the machine into swapping? > I get this message when I try to cancel the query: > > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > The connection to the server was lost. Attempting reset: Failed. Did you send a kill of some kind to the backend? > The machine has 2x Intel dual core processors (3GHz) and 2 Gigs of ram. Unless I missed some big news recently, no such CPU exists. Hyperthreading is absolutely not the same as dual core, and many people have found that it's best to disable hyperthreading on database servers. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461