Re: VACUUM and open transactions

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?