Martijn van Oosterhout <kleptog@xxxxxxxxx> 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
