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

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

主站蜘蛛池模板: 确山县| 和龙市| 佛山市| 临江市| 双牌县| 家居| 武汉市| 上思县| 德令哈市| 会昌县| 九寨沟县| 长沙市| 平果县| 安乡县| 龙川县| 重庆市| 文安县| 高平市| 陆川县| 县级市| 巧家县| 韶关市| 霍山县| 连山| 广元市| 虞城县| 克什克腾旗| 乐清市| 岚皋县| 黄冈市| 西藏| 红原县| 崇左市| 青神县| 卫辉市| 辛集市| 万源市| 读书| 西华县| 康乐县| 涟水县|