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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
