Wednesday, April 9, 2014

Why aren't multi-object updates atomic?

Losing ACID across shards isn't an excuse for not having it within a shard. Applications control the shard key and can co-locate data that would benefit from this feature. Performance imperfections in the product, limits in the product and application data models will require this in some deployments.

No comments:

Post a Comment

Postgres 17.4 vs sysbench on a large server, revisited part 2

I recently shared two posts ( here and here ) with results for sysbench on a large server using Postgres versions 10 through 17. In general...