AMAZINGINDEX.COM 每日 AI 简报
53.0
VOL. 2026.06
2026.06.11
← 返回 2026.06.11 日报
日报快照 · Daily Snapshot
NO. 011

PgDog 融资:Postgres 水平扩展代理

#ARTICLE HackerNews 2026.06.11
值得看指数 63.0 NO. 011 · 2026.06.11
发布2026/06/10Score294Comments155

PgDog 是一个 Postgres 代理层,通过透明分片让单库水平扩展到 100TB+ 和百万 QPS,已处理生产环境 200 万 QPS。对不想迁移到专用分布式数据库的团队,这可能是保留 Postgres 生态的最小改动方案。

Postgres 分片不是新需求,但现有方案要么侵入性强(Citus 改查询语法、YugabyteDB 换存储引擎),要么运维重(手动分片+应用层路由)。PgDog 走透明代理路线,对应用零改造,这直接对标了几年前 PlanetScale 对 MySQL 做的事。

关键风险在于:透明分片的查询路由和跨分片事务一致性很难做好,尤其是复杂 JOIN 和聚合。PgDog 声称已跑 200 万 QPS,但 HN 讨论里有人质疑其分片策略细节未公开。如果查询模式复杂,建议先拿只读分析场景试水,而非直接替换核心交易库。

意见分歧 140 条评论

核心争论:PgDog 能否在保持 Postgres 生态的同时,真正替代专用分布式数据库的扩展能力

htrp

>PgDog is a sharder, connection pooler and load balancer for PostgreSQL. Written in Rust, PgDog is fast, reliable and scales databases horizontally without requiring changes to application code. Still trying to figure out how this works technically, is the performance gain really just re-write in ru

levkk

Not quite. The performance gain is to bring those features to Postgres! Edit: Performance gains are from having the ability to load balance reads (horizontal scaling for read queries) and scale out writes (with sharding). Once instance bottleneck in Postgres has many faces: 1. Behind schedule vacuum

VeninVidiaVicii

Oh thanks for clearing that up.

替代方案: AWS AuroraPG bouncer
查看原文 →