See also Postgres multi-version concurrency control. Doesn't solve the problem of merging incompatible inatomic-concurrent changes.