Re: VACUUM and open transactions - Mailing list pgsql-general

From Joseph S
Subject Re: VACUUM and open transactions
Date
Msg-id 4537DF25.7020205@selectacast.net
Whole thread Raw
In response to Re: VACUUM and open transactions  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: VACUUM and open transactions
List pgsql-general
Martijn van Oosterhout wrote:

> Sure, don't keep transactions open for so long. Is there a particular
> reason you do that?

Because I have a leak somewhere?  Even if the transaction isn't that old
it will still cause me some table bloat in the meantime.
>
> The problem is that the "old" transaction can see effects of later
> started transactions, so VACUUM can't delete the later stuff either...

How can it see effects of transactions that started after it?

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: VACUUM and open transactions
Next
From: Martijn van Oosterhout
Date:
Subject: Re: VACUUM and open transactions