- Mastering PostgreSQL 9.6
- Hans Jurgen Schonig
- 62字
- 2021-07-09 19:57:09
Improving vacuum speed
PostgreSQL 9.6 not only provides you with deeper insights into what vacuum does at the moment, it will also speed up the process in general. From PostgreSQL 9.6 onward, PostgreSQL will keep track of all frozen pages and avoid vacuuming those pages.
Tables that are mostly read-only will massively benefit from this change, as vacuum load is drastically reduced.
推薦閱讀
- 現(xiàn)代測(cè)控電子技術(shù)
- SharePoint 2010開(kāi)發(fā)最佳實(shí)踐
- Associations and Correlations
- 21天學(xué)通Java
- 工業(yè)機(jī)器人應(yīng)用案例集錦
- PostgreSQL 10 Administration Cookbook
- Azure PowerShell Quick Start Guide
- 手機(jī)游戲程序開(kāi)發(fā)
- Spatial Analytics with ArcGIS
- Linux內(nèi)核精析
- Flink原理與實(shí)踐
- 深度學(xué)習(xí)原理與 TensorFlow實(shí)踐
- 大數(shù)據(jù)時(shí)代的調(diào)查師
- 特征工程入門與實(shí)踐
- 數(shù)據(jù)結(jié)構(gòu)與實(shí)訓(xùn)