# MVCC in the Cloud

DevFeed: [MVCC in the Cloud](<https://devfeed.tech/articles/mvcc-in-the-cloud-34374.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2010/07/mvcc-in-the-cloud/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2010-07-06T08:50:00Z

Content type: opinion

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [Cloud](<https://devfeed.tech/topics/cloud.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [cloud](<https://devfeed.tech/tags/cloud.md>), [database](<https://devfeed.tech/tags/database.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [join](<https://devfeed.tech/tags/join.md>), [latency](<https://devfeed.tech/tags/latency.md>), [mvcc](<https://devfeed.tech/tags/mvcc.md>), [network](<https://devfeed.tech/tags/network.md>), [parallel](<https://devfeed.tech/tags/parallel.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

The article examines whether Postgres-R is ready for cloud use, arguing that while it supports elasticity and read scalability across database nodes, write scalability remains unresolved. It proposes remote and mirrored tablespaces for distributing data and processing while preserving transaction boundaries.

## Source excerpt

At CHAR(10) Markus had a talk about Using MVCC for Clustered Database Systems and explained how Postgres-R does it. The scope of his project is to maintain a set of database servers in the same state, eventually. Now, what does it mean to get "In the Cloud"? Well there are more than one answer I'm sure, mine would insist on including this "Elasticity" bit. What I mean here is that it'd be great to be able to add or lose nodes and stay online. Granted, that what's Postgres-R is providing. Does that make it ready for the "Cloud"? Well it happens so that I don't think so.