匿名用户clusterdb的适用场景
pg中clusterdb这个命令,啥场景适用??有什么命令或者指标来判断,需要做clusterdb操作了
我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏
匿名用户pg中clusterdb这个命令,啥场景适用??有什么命令或者指标来判断,需要做clusterdb操作了
有一本书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
墨值悬赏