An Overview of Distributed PostgreSQL Architectures | Crunchy Data Blog
Automated high availability PostgreSQL solutions for traditional self-managed deployments on VMs and traditional infrastructure. High availability production deployment for self-managed PostgreSQL deployed through a Kubernetes Operator. Hardened, secure, access controlled PostgreSQL to meet advanced security requirements. Marco Slot I've always found distributed systems to be the most fascinating branch of computer science. I think the reason is that distributed systems are subject to the rules of the physical world just like we are. Things are never perfect, you cannot get everything you want, you’re always limited by physics, and often by economics, or by who you can communicate with. Many problems in distributed systems simply do not have a clean solution, instead there are different trade-offs you can make. While at Citus Data, Microsoft, and now Crunchy Data, the focus of my work has been on distributed PostgreSQL architectures. At the last PGConf.EU in December, I gave a talk tit
Marco Slot Jan 8, 2024 · 16 min read More by this author Latest Articles British Columbia, Time Zones, and Postgres Postgres Serials Should be BIGINT (and How to Migrate) Postgres 18 New Default for Data Checksums and How to Deal with Upgrades PostGIS Performance: Simplification Postgres Scan Types in EXPLAIN Plans Production Postgres An Overview of Distributed PostgreSQL Architectures Marco Slot Jan 8, 2024 · 16 min read · More by this author I've always found distributed systems to be the most fascinating branch of computer science. I think the reason is that distributed systems are subject
saved by
related reading
- Blog — PlanetScaleplanetscale.com
- Making 768 servers look like 1 — PlanetScaleplanetscale.com
- The most useful Postgres extension: pg_stat_statements - Citus Datacitusdata.com
- Patching the PostgreSQL JDBC Driverengineering.zalando.com
- A Distributed Systems Reading Listferd.ca
- Nine ways to shoot yourself in the foot with PostgreSQLphilbooth.me
- PostgreSQL rocks, except when it blocks: Understanding locks - Citus Datacitusdata.com
- Schedule | POSETTE: An Event for Postgres 2024 - Citus Datacitusdata.com
- Just Use Postgres for Everything | Amazing CTOamazingcto.com
- Postgres WAL Files and Sequence Numbers | Crunchy Data Blogcrunchydata.com
- The lifecycle of a sharded Postgres query — PlanetScaleplanetscale.com
- Benchmarking How Workflow Execution Scales on Postgres | DBOSdbos.dev