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

CPU-bound sysbench on a large server: Postgres 12 to 19 beta1

This has results from sysbench on a small server with Postgres versions 12 through 19 beta1. Sysbench is run with high concurrency (40 conne...