X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3FF3853B2B for ; Thu, 14 Apr 2005 14:34:04 -0300 (ADT) 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 28659-02 for ; Thu, 14 Apr 2005 17:34:01 +0000 (GMT) Received: from smtp105.rog.mail.re2.yahoo.com (smtp105.rog.mail.re2.yahoo.com [206.190.36.83]) by svr1.postgresql.org (Postfix) with SMTP id 019425296B for ; Thu, 14 Apr 2005 14:33:59 -0300 (ADT) Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@216.75.167.195 with login) by smtp105.rog.mail.re2.yahoo.com with SMTP; 14 Apr 2005 17:33:59 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id D1DDE3F9C; Thu, 14 Apr 2005 13:33:58 -0400 (EDT) Date: Thu, 14 Apr 2005 13:33:58 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: row-attribute in EXPLAIN-output doesn't match count(*) Message-ID: <20050414173358.GB9027@phlogiston.dyndns.org> References: <200504141838.14705.andreak@officenet.no> <425EA496.2030501@archonet.com> <200504141921.38476.andreak@officenet.no> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200504141921.38476.andreak@officenet.no> User-Agent: Mutt/1.5.6+20040907i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.048 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/203 X-Sequence-Number: 21096 On Thu, Apr 14, 2005 at 07:21:38PM +0200, Andreas Joseph Krogh wrote: > > So, what you're suggesting is that a restart of the webapp should make vacuum > able to delete those dead rows? Yes, but that'll only solve your problem for now. You'll have the problem again soon. What's keeping open the transaction? A -- Andrew Sullivan | ajs@crankycanuck.ca The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun