Re: vacuum vs open transactions

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