Noah Misch wrote: > On Sun, Jun 14, 2015 at 12:37:00PM +0200, Magnus Hagander wrote:
> > Would we in that case want to enforce linearity *and* recent-ness, or just > > linearity? as in, do we care about the commit time even if it doesn't > > change the order? > > If a recency check is essentially free, let's check both. Otherwise, > enforcing linearity alone is a 95% solution that implicitly bounds recency. Should there also be a check to reject times too far in the future? I think a clock skew of a few minutes (up to ten?) is acceptable, but more than that would cause trouble for other committers later on. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers