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

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.

主站蜘蛛池模板: 威信县| 宜兰县| 连云港市| 余干县| 确山县| 永福县| 杭锦旗| 安仁县| 六枝特区| 汉沽区| 鹤庆县| 黄梅县| 隆安县| 磐安县| 大余县| 依安县| 若尔盖县| 崇州市| 哈尔滨市| 临城县| 正蓝旗| 兰西县| 万山特区| 广昌县| 波密县| 利川市| 米泉市| 宣城市| 梨树县| 东海县| 崇明县| 南召县| 会东县| 沾益县| 娄底市| 县级市| 盐城市| 北安市| 绍兴市| 盐池县| 建平县|