暂无图片
clusterdb的适用场景
我来答
分享
暂无图片 匿名用户
clusterdb的适用场景

pg中clusterdb这个命令,啥场景适用??有什么命令或者指标来判断,需要做clusterdb操作了

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
彭冲

有一本书Learning PostgreSQL有一段介绍,供参考:

PostgreSQL also provides tools to maintain the system objects, mainly clusterdb and
reindexdb. clusterdb is a wrapper around the CLUSTER statement, which is used to
physically reorder the table based on certain index information. This can increase databaseperformance read operations due to the locality of reference principles, mainly the spatial
locality. Clustering the table helps to retrieve data from adjacent storage blocks and thus
reduces the hard-disk-access cost.

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏