Re: vacuum vs open transactions

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum vs open transactions
Date: 2005-01-12 18:49:12
Message-ID: 200501121149.12804.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday January 12 2005 11:10, Scott Marlowe wrote:
>
> I believe the problem is occurring if the open transaction is older than
> the tuples that could be vacuumed. The MVCC system means that as long
> as a transaction that started X hours ago is still open, the tuples that
> have been freed since then can't vacuumed because they need to stay
> visible for that transaction.

Is it possible via SQL query to tell how long a transaction has been open?

Ed

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2005-01-12 18:53:51 Re: Much Ado About COUNT(*)
Previous Message Michael Fuhr 2005-01-12 18:42:42 Re: Postgresql 8.0 and Cancel/Kill backend functions