Andrew Dunstan <andrew.duns...@2ndquadrant.com> writes: > What I have done quickly is to store a measure of the clock skew. We > already calculated it but we didn't store it. Initial indications are > that only a few have significant skew.
Oh, I didn't know that the server had the ability to measure that. (Yes, I agree that there are just a couple with big skews at any one time.) > Still, if we simply added the skew to the snapshot time that might be > enough to achieve what you want. That would be a one line change, I think. +1 regards, tom lane