- 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.
推薦閱讀
- 課課通計算機原理
- Oracle SOA Governance 11g Implementation
- Go Machine Learning Projects
- Visual C# 2008開發技術詳解
- 智能工業報警系統
- 構建高性能Web站點
- Apache Superset Quick Start Guide
- Storm應用實踐:實時事務處理之策略
- 工業機器人運動仿真編程實踐:基于Android和OpenGL
- Practical AWS Networking
- RealFlow流體制作經典實例解析
- Mastering MongoDB 4.x
- PostgreSQL High Performance Cookbook
- 電氣自動化工程師自學寶典(基礎篇)
- Mastering Kubernetes