"Distributed"
- PostgreSQL Citus Distributed:用 extension 把 PG 變成 sharded cluster
Citus 是 PG extension、把單機 PG 變成 *coordinator + worker* sharded cluster、保留 PG SQL + 加 distributed table + reference table + columnar storage。本文走 Citus 架構(coordinator / worker / distribution column)、3 種 table type(distributed / reference / local)、配置 step-by-step、5 production 踩雷(distribution column 選錯 / cross-shard transaction / reference table 過大 / colocate 不對齊 / worker failover)、跟 MySQL Vitess sharding sibling 對比