Before we begin a comparison blog post about PostgreSQL, we must first acknowledge that it is one of the most reliable and widely used databases in the history of software. The world owes a debt of gratitude to the open source community that has built and supported this important project for the last 35 years.
In this post, we unpack some of the architectural differences between PostgreSQL and CockroachDB. We’ll point out where the limitations of single server, single instance architecture might pose challenges for modern cloud infrastructure, and how a distributed foundation can be a better solution for your apps and services.