From: Richard Huxton <dev@archonet.com>
To: Andreas Joseph Krogh <andreak@officenet.no>
Cc: pgsql-sql@postgresql.org
Subject: Re: row-attribute in EXPLAIN-output doesn't match count(*)
Date: Thu, 14 Apr 2005 19:48:54 +0100
Message-ID: <425EBB16.4040900@archonet.com> (raw)
In-Reply-To: <200504141921.38476.andreak@officenet.no>
References: <200504141838.14705.andreak@officenet.no>
<425EA496.2030501@archonet.com>
<200504141921.38476.andreak@officenet.no>
Andreas Joseph Krogh wrote:
> On Thursday 14 April 2005 19:12, Richard Huxton wrote:
>>
>>So - do you have an application/client that has had a single transaction
>>open for a long time. A very long time unless you update this table a lot.
>
>
> Hm, it's a web-app, and I don't hold a transaction open for a long time on
> purpose, but I have a line which says "idle in transaction" fromn "ps":
>
> postgres 2754 1646 0 Apr06 ? 00:00:07 postgres: nbe nbeweb 127.0.0.1
> idle in transaction
Some Java systems can open a transaction and leave it there idle. That
one's been there since April 6th.
> And by the way, I lied about the PG-version, it's 7.4.5, not 8.0.0
>
> So, what you're suggesting is that a restart of the webapp should make vacuum
> able to delete those dead rows?
Exactly.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, andreak@officenet.no
Subject: Re: row-attribute in EXPLAIN-output doesn't match count(*)
In-Reply-To: <425EBB16.4040900@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox