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

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.

主站蜘蛛池模板: 扬中市| 芮城县| 宜君县| 墨竹工卡县| 新沂市| 扬中市| 岑巩县| 岑溪市| 手机| 阿拉善盟| 麻城市| 临猗县| 洛扎县| 高唐县| 贵德县| 辉县市| 梧州市| 禄丰县| 西乌珠穆沁旗| 肇东市| 岑溪市| 攀枝花市| 龙井市| 山丹县| 建阳市| 吉首市| 云龙县| 洛隆县| 临清市| 寿光市| 田林县| 永定县| 利津县| 罗定市| 卢氏县| 远安县| 武隆县| 南阳市| 青阳县| 吉林省| 陕西省|