An Overview of Distributed PostgreSQL Architectures - Nick the Sick's blog. Writings, projects and ideas.

# An Overview of Distributed PostgreSQL Architectures - Crunchy Data Synced: [[2024_01_10]] 2:37 PM Last Highlighted: [[2024_01_09]] ![rw-book-cover](https://imagedelivery.net/lPM0ntuwQfh8VQgJRu0mFg/4ab7d28c-727c-4d5b-d644-a0c31eb78000/public) ## Highlights [[2024_01_09]] [View Highlight](https://read.readwise.io/read/01hkpsbpcns2z6c2ss0nf15r13) > There are several mechanisms that distributed database systems employ to achieve this, namely: > • Replication - Place copies of data on different machines > • Distribution - Place partitions of data on different machines > • Decentralization - Place different DBMS activities on different machines