Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id BA8799FB348 for ; Thu, 26 Oct 2006 01:22:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 74050-10 for ; Thu, 26 Oct 2006 04:21:57 +0000 (UTC) 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 E34939FB1CA for ; Thu, 26 Oct 2006 01:21:56 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 8EC0256427; Wed, 25 Oct 2006 23:21:53 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 25 Oct 2006 23:21:50 -0500 Date: Wed, 25 Oct 2006 23:21:50 -0500 From: "Jim C. Nasby" To: Carlo Stonebanks Cc: 'Brian Hurt' , pgsql-performance@postgresql.org Subject: Re: commit so slow program looks frozen Message-ID: <20061026042150.GD26892@nasby.net> References: <453FC6AB.5090105@janestcapital.com> <036901c6f874$a907e700$6f05a8c0@Mars> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <036901c6f874$a907e700$6f05a8c0@Mars> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:061026:stonec.register@sympatico.ca::8puS0KH1XWcf4EIC:000000000 0000000000000000000000004QpF X-Hashcash: 1:20:061026:bhurt@janestcapital.com::2IBC7nJ8dRgveT/f:00000000000000 0000000000000000000000000xJO X-Hashcash: 1:20:061026:pgsql-performance@postgresql.org::ATB5GeTcmHcIm8oa:00000 0000000000000000000000001JDo X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/543 X-Sequence-Number: 21672 On Wed, Oct 25, 2006 at 04:32:16PM -0400, Carlo Stonebanks wrote: > >> I have a question for you: did you have a long running query keeping open > a transaction? I've just noticed the same problem here, but things cleaned > up immediately when I aborted the long-running transaction. > > No, the only processes are from those in the import applications themselves: > short transactions never lasting more than a fraction of a second. Do you have a linux/unix machine you could reproduce this on? -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)