Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E7D5C9FA6B5 for ; Wed, 25 Oct 2006 17:32:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 64199-07 for ; Wed, 25 Oct 2006 17:32:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from tomts40-srv.bellnexxia.net (tomts40.bellnexxia.net [209.226.175.97]) by postgresql.org (Postfix) with ESMTP id 03C809FA621 for ; Wed, 25 Oct 2006 17:32:16 -0300 (ADT) Received: from Mars ([70.55.135.113]) by tomts40-srv.bellnexxia.net (InterMail vM.5.01.06.13 201-253-122-130-113-20050324) with ESMTP id <20061025203215.QIOJ24981.tomts40-srv.bellnexxia.net@Mars>; Wed, 25 Oct 2006 16:32:15 -0400 From: "Carlo Stonebanks" To: "'Brian Hurt'" Cc: Subject: Re: commit so slow program looks frozen Date: Wed, 25 Oct 2006 16:32:16 -0400 Message-ID: <036901c6f874$a907e700$6f05a8c0@Mars> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_036A_01C6F853.21F64700" X-Mailer: Microsoft Office Outlook 11 Thread-Index: Acb4c08uLvDdJ4i1T7GwdjkTjy0uRAAANKRQ In-Reply-To: <453FC6AB.5090105@janestcapital.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/531 X-Sequence-Number: 21660 This is a multi-part message in MIME format. ------=_NextPart_000_036A_01C6F853.21F64700 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit >> 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. Carlo ------=_NextPart_000_036A_01C6F853.21F64700 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

>> 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.

 

Carlo

------=_NextPart_000_036A_01C6F853.21F64700--