On 8/21/19 4:16 PM, Tom Lane wrote: > 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 > >
Done. It's only happening prospectively, so we'll need to wait a few days to see it flow through. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
