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?
