本文探讨了Postgres数据库中不可变行数据的核心设计——元组及其唯一标识actid的概念，并分析了这一设计带来的写入放大及同步放大等问题。
One of the core design aspects of Postgres is immutable row data. These immutable rows are called “tuples” in Postgres parlance. These tuples are uniquely identified by what Postgres calls a ctid. A ctid conceptually represents the on-disk location (i.e., physical disk offset) for a tuple. Multiple ctids can potentially describe a single row
pg的这个核心设计会导致一系列的问题, 核心指标上更 expensive.
1.写入放大
2.同步放大
扫一扫
2578
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
