Notion 实现 PostgreSQL 查询流水线提升性能
Notion 工程师分享了他们如何通过 PostgreSQL 查询流水线将性能提升 50%,具体代码示例很实用。
Notion 工程师 Jake 实现了 PostgreSQL 扩展查询协议流水线技术。该技术将查询网络往返次数从 N 次减少到 1 次(读)或 2 次(写)。
Notion 的查询性能因此提升了约 50%。Notion 在事务中运行大量查询,配合 pgbouncer 事务池使用效果更佳。
i enjoy posting about new features. i enjoy posting about performance improvement more. Jake 🎉 @jitl implemented postgres extended query protocol pipelining, makes queries at notion go about 50% faster why? notion runs many queries in transactions so we can use pgbouncer txn pooling + SET LOCAL; many reads look like this: await query(sql`BEGIN; SET LOCAL search_path = ...`) const result = await query(sql`SELECT ...`) // rare txns sometimes do more reads await query(sql`COMMIT`) pipelining which reduces network round trips from N → 1 for reads and N → 2 for writes (tho maybe its fine to pipeline COMMIT there also) const results = await query(new ExtendedQueryPipeline([ sql`BEGIN`, sql`SET LOCAL ...`, sql`SELECT ...`, sql`COMMIT`, ])) 🔗 View Quoted Tweet📊 4 ⚡
This report is categorized under AITOP's "How-to" desk, focusing on US frontier AI labs and Silicon Valley technology leaders. Within our cross-regional analytical framework, it directly maps to AI developer toolchains, coding agents, and engineering workflows. Key entities and technical topics under continuous tracking include PostgreSQL, Notion, query optimization, performance improvements.
Source attribution: curated from Akshay Kothari (@akothari).