X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 24E33329C7B for ; Sun, 19 Sep 2004 22:55:31 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20011-07 for ; Sun, 19 Sep 2004 21:55:25 +0000 (GMT) Received: from a.mx.zettai.net (a.mx.zettai.net [207.58.154.6]) by svr1.postgresql.org (Postfix) with ESMTP id DA72C329E15 for ; Sun, 19 Sep 2004 22:55:25 +0100 (BST) Received: (qmail 11747 invoked by uid 1012); 19 Sep 2004 21:55:26 -0000 Received: from robb@acm.org by beta.zettai.net by uid 89 with qmail-scanner-1.22 (clamdscan: 0.70. spamassassin: 2.63. Clear:RC:1(67.171.31.36):. Processed in 0.029536 secs); 19 Sep 2004 21:55:26 -0000 Received: from unknown (HELO ?192.168.0.100?) (robert@greenfabrik.com@67.171.31.36) by 0 with (DHE-RSA-AES256-SHA encrypted) SMTP; 19 Sep 2004 21:55:26 -0000 Message-ID: <414E0044.2070108@acm.org> Date: Sun, 19 Sep 2004 14:55:16 -0700 From: Robb Shecter User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: All ops on one particular table cause a hang? References: <414DF72F.8010906@acm.org> <28913.1095629830@sss.pgh.pa.us> In-Reply-To: <28913.1095629830@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/168 X-Sequence-Number: 14871 Tom Lane wrote: >Maybe you've got a session that is holding an exclusive lock on that >table? > > Yes - you are absolutely right. I had an application that did not properly close its database connection... Thanks! Robb