- 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.
推薦閱讀
- 計算機(jī)應(yīng)用
- 大數(shù)據(jù)技術(shù)基礎(chǔ)
- 我的J2EE成功之路
- 高性能混合信號ARM:ADuC7xxx原理與應(yīng)用開發(fā)
- PowerShell 3.0 Advanced Administration Handbook
- 機(jī)艙監(jiān)測與主機(jī)遙控
- 大數(shù)據(jù)技術(shù)入門(第2版)
- 網(wǎng)絡(luò)綜合布線設(shè)計與施工技術(shù)
- 人工智能實(shí)踐錄
- Blender 3D Printing by Example
- Docker on Amazon Web Services
- PVCBOT機(jī)器人控制技術(shù)入門
- Excel 2010函數(shù)與公式速查手冊
- Apache源代碼全景分析(第1卷):體系結(jié)構(gòu)與核心模塊
- 智能鼠原理與制作(進(jìn)階篇)