官术网_书友最值得收藏!

A word on VACUUM FULL

Instead of normal VACUUM, you can also use VACUUM FULL. However, I really want to point out that VACUUM FULL actually locks the table and rewrites the entire relation. In the case of a small table, this might not be an issue. However, if your tables are large, the table lock can really kill you in minutes! VACUUM FULL blocks upcoming writes and therefore some people talking to your database might have the feeling that it is actually down. Hence, a lot of caution is advised.

To get rid of VACUUM FULL, I recommend that you check out pg_squeeze (http://www.cybertec.at/introducing-pg_squeeze-a-postgresql-extension-to-auto-rebuild-bloated-tables/), which can rewrite a table without blocking writes.

主站蜘蛛池模板: 贡觉县| 镇康县| 宝应县| 鄂伦春自治旗| 瑞金市| 铁岭县| 乐清市| 临西县| 家居| 嵊泗县| 友谊县| 南投市| 高雄市| 青河县| 郑州市| 仁怀市| 驻马店市| 荃湾区| 信阳市| 融水| 濮阳县| 永顺县| 策勒县| 平湖市| 铜鼓县| 通道| 南漳县| 保德县| 迁西县| 龙门县| 金山区| 临夏县| 建湖县| 合江县| 哈密市| 大洼县| 临西县| 恩平市| 遂平县| 渭南市| 澄迈县|