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

  • Mastering PostgreSQL 9.6
  • Hans Jurgen Schonig
  • 114字
  • 2021-07-09 19:57:14

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.

主站蜘蛛池模板: 铜鼓县| 平陆县| 上蔡县| 磴口县| 定安县| 桂东县| 于田县| 修武县| 从江县| 新巴尔虎右旗| 美姑县| 青铜峡市| 包头市| 久治县| 黄大仙区| 松滋市| 宿迁市| 凉城县| 兴海县| 延庆县| 无棣县| 五河县| 福鼎市| 延吉市| 长治县| 巴中市| 皮山县| 饶阳县| 彰武县| 台江县| 武胜县| 永登县| 南丹县| 神农架林区| 仁怀市| 象州县| 望奎县| 察哈| 丹棱县| 克什克腾旗| 炉霍县|