Postgres Pro
Downloads
Home   >   mailing lists

Re: row-attribute in EXPLAIN-output doesn't match count(*) - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: row-attribute in EXPLAIN-output doesn't match count(*)
Date
Msg-id 20050414173358.GB9027@phlogiston.dyndns.org
Whole thread Raw
In response to Re: row-attribute in EXPLAIN-output doesn't match count(*)  (Andreas Joseph Krogh <andreak@officenet.no>)
Responses Re: row-attribute in EXPLAIN-output doesn't match count(*)  (Andreas Joseph Krogh <andreak@officenet.no>)
Re: row-attribute in EXPLAIN-output doesn't match count(*)  (Greg Stark <gsstark@mit.edu>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: row-attribute in EXPLAIN-output doesn't match count(*)
Next
From: "Moran.Michael"
Date:
Subject: Re: PGCrypto: Realworld scenario and advice needed