- 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.
推薦閱讀
- 數(shù)據(jù)展現(xiàn)的藝術(shù)
- 輕松學(xué)C語言
- Mastering Spark for Data Science
- Mastering Salesforce CRM Administration
- 工業(yè)機(jī)器人入門實用教程(KUKA機(jī)器人)
- 計算機(jī)網(wǎng)絡(luò)技術(shù)實訓(xùn)
- 大學(xué)計算機(jī)應(yīng)用基礎(chǔ)
- 網(wǎng)絡(luò)化分布式系統(tǒng)預(yù)測控制
- 精通數(shù)據(jù)科學(xué)算法
- 網(wǎng)絡(luò)布線與小型局域網(wǎng)搭建
- MCGS嵌入版組態(tài)軟件應(yīng)用教程
- Linux Shell編程從初學(xué)到精通
- Windows安全指南
- 青少年VEX IQ機(jī)器人實訓(xùn)課程(初級)
- Hands-On SAS for Data Analysis