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?