官术网_书友最值得收藏!

  • 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.

主站蜘蛛池模板: 黑山县| 贺州市| 昌乐县| 富阳市| 婺源县| 赤壁市| 东丽区| 绥中县| 阿拉善盟| 任丘市| 凉城县| 苏州市| 海安县| 页游| 托克逊县| 揭东县| 兴化市| 沁源县| 惠来县| 景东| 乐山市| 和林格尔县| 苏尼特左旗| 钟山县| 广汉市| 无为县| 彭州市| 阿克| 铁力市| 十堰市| 江油市| 台安县| 平山县| 保亭| 江城| 洞头县| 丽江市| 始兴县| 澎湖县| 阿巴嘎旗| 岫岩|