- 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.
推薦閱讀
- 21天學(xué)通JavaScript
- 控制與決策系統(tǒng)仿真
- 數(shù)據(jù)運(yùn)營之路:掘金數(shù)據(jù)化時(shí)代
- 物聯(lián)網(wǎng)與云計(jì)算
- 網(wǎng)絡(luò)綜合布線技術(shù)
- Mastering Elastic Stack
- 自動(dòng)生產(chǎn)線的拆裝與調(diào)試
- 基于ARM 32位高速嵌入式微控制器
- Hybrid Cloud for Architects
- 內(nèi)模控制及其應(yīng)用
- 深度學(xué)習(xí)與目標(biāo)檢測
- Word 2007,Excel 2007辦公應(yīng)用融會(huì)貫通
- 在實(shí)戰(zhàn)中成長:Windows Forms開發(fā)之路
- SQL Server數(shù)據(jù)庫應(yīng)用基礎(chǔ)(第2版)
- 重估:人工智能與賦能社會(huì)