Martijn van Oosterhout <kleptog@svana.org> writes:
> A VACUUM will recover any data that slipped beyond the horizon less
> than 1 billion transactions ago, which I think covers you completely.
> The only issue is that unique indexes may be confused because new
> conflicting data may have been inserted while the old data was
> invisible. Only you can say if that's going to be an issue.
I don't think there's a risk there. Uniqueness checks use SnapshotDirty
so they aren't time-sensitive.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
