- Mastering PostgreSQL 9.6
- Hans Jurgen Schonig
- 79字
- 2021-07-09 19:57:10
Improving relation extensions
For many years PostgreSQL has extended a table (or an index) block by block. In the case of a single writer process, this was usually fine. However, in cases of high-concurrency writing, writing a block at a time was a source of contention and suboptimal performance. From 9.6 onward, PostgreSQL started to extend tables by multiple blocks at a time. The number of blocks added at a time is 20 times the number of waiting processes.
推薦閱讀
- ETL with Azure Cookbook
- Hands-On Data Science with SQL Server 2017
- iClone 4.31 3D Animation Beginner's Guide
- 大數(shù)據(jù)平臺異常檢測分析系統(tǒng)的若干關(guān)鍵技術(shù)研究
- 21天學(xué)通Visual C++
- 大學(xué)C/C++語言程序設(shè)計(jì)基礎(chǔ)
- 項(xiàng)目管理成功利器Project 2007全程解析
- 工業(yè)機(jī)器人安裝與調(diào)試
- PVCBOT機(jī)器人控制技術(shù)入門
- 網(wǎng)站前臺設(shè)計(jì)綜合實(shí)訓(xùn)
- Photoshop行業(yè)應(yīng)用基礎(chǔ)
- 基于RPA技術(shù)財(cái)務(wù)機(jī)器人的應(yīng)用與研究
- Photoshop CS4數(shù)碼照片處理入門、進(jìn)階與提高
- Embedded Linux Development using Yocto Projects(Second Edition)
- 系統(tǒng)建模與控制導(dǎo)論