- 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.
推薦閱讀
- Instant Raspberry Pi Gaming
- 計(jì)算機(jī)應(yīng)用
- 網(wǎng)頁編程技術(shù)
- 網(wǎng)上生活必備
- 21天學(xué)通C++
- 智能工業(yè)報(bào)警系統(tǒng)
- 21天學(xué)通C#
- PostgreSQL Administration Essentials
- 人工智能與人工生命
- WordPress Theme Development Beginner's Guide(Third Edition)
- 水晶石精粹:3ds max & ZBrush三維數(shù)字靜幀藝術(shù)
- 深度學(xué)習(xí)與目標(biāo)檢測(cè)
- Linux常用命令簡明手冊(cè)
- 網(wǎng)絡(luò)信息安全項(xiàng)目教程
- 當(dāng)產(chǎn)品經(jīng)理遇到人工智能