nonremovable row versions

From: Lutz Steinborn <l(dot)steinborn(at)4c-ag(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: nonremovable row versions
Date: 2009-06-08 06:28:59
Message-ID: 20090608082859.930afeb3.l.steinborn@4c-ag.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

can anybody tell me how to get rid of nonremovable row versions ?
I know what those rows coming from long running transactions. But I can't see
any long running transactions in pg_locks and all postgres processes are idle.
How else can I check if transaction in process ?

I don't have any idea from where those long running transaction are comming
because we are stopping/starting our apllications every 2-3 days. And its not
the nature of our applications to establish long running transactions.

We are using postgresql 8.1.4.

Kindly regards
Lutz
4c GmbH

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-06-08 07:14:53 Re: nonremovable row versions
Previous Message Milen A. Radev 2009-06-06 17:59:11 Re: Who knows this SELECT in PostgreSQL