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

  • 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.

主站蜘蛛池模板: 华宁县| 全州县| 龙陵县| 库尔勒市| 西乡县| 嘉定区| 博乐市| 扎鲁特旗| 正安县| 庆元县| 文化| 喀喇沁旗| 双流县| 依安县| 年辖:市辖区| 镇沅| 洪洞县| 巴彦淖尔市| 丹凤县| 阜平县| 浪卡子县| 蒙城县| 会理县| 青岛市| 六安市| 宜城市| 临沭县| 横山县| 清镇市| 苏尼特右旗| 江城| 龙陵县| 额尔古纳市| 淅川县| 镇沅| 镇赉县| 中山市| 衡南县| 金秀| 阿瓦提县| 岐山县|