Building reliable infrastructure with Postgres
summary
PostgresPro describes a fork aimed at huge enterprise installs with built‑in HA cluster and multi‑master replication, a sharding system running a 300 TB installation across about 26–28 servers handling a billion transactions per week. It reports a proxy that reconnects clients and a pooler plus a cache with Redis‑style invalidation, page‑level compression to cut IO, ML‑based adaptive query optimization, and RDMA‑backed hardware/software sync to speed distributed writes.
AI-written summary · about
chapters (7)
- 0:00Introduction and overview
- 1:09Enterprise Postgres challenges
- 2:57Reliability features in Postgres
- 5:05High availability and sharding
- 7:53Performance optimizations
- 10:23Distributed system improvements
- 11:51S3 integration and data lifecycle
related talks
51mScaling Postgres to the next level at OpenAI
36mPostgres at any Scale
29mBuilding Enterprise Grade PostgreSQL using Percona distribution for PostgreSQL
54mBreakout Session
46mDeploying Maximum HA Architecture With Postgres
58mScaling Postgres
38mWhat we built with Open Source
46mBig databases, many servers, data center or cloud - it's all here!