首页 > 数据库技术 > 详细

postgresql vacuum table

时间:2017-10-25 15:02:30      阅读:281      评论:0      收藏:0      [点我收藏+]

 

according to Documentation

VACUUM reclaims storage occupied by dead tuples.

But according to this post

Dead rows are deleted rows that will later be reused for new rows from INSERTs or UPDATEs. Some dead rows (or reserved free space) can be particularly useful for HOT (Heap-Only Tuples) updates that can reuse space in the same data page efficiently

postgresql vacuum table

原文:http://www.cnblogs.com/oxspirt/p/7728541.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!