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

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.

主站蜘蛛池模板: 乐业县| 多伦县| 温宿县| 平凉市| 和政县| 南岸区| 彝良县| 马关县| 永城市| 凌源市| 墨玉县| 阳西县| 宝清县| 湾仔区| 湘潭县| 扎兰屯市| 沧源| 晋宁县| 郓城县| 平定县| 平利县| 柘荣县| 正宁县| 科尔| 古交市| 孟州市| 荔浦县| 岑巩县| 仲巴县| 砀山县| 永丰县| 清新县| 田东县| 赤峰市| 新沂市| 乐平市| 石台县| 黎城县| 夏河县| 巫溪县| 封开县|