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

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.

主站蜘蛛池模板: 日喀则市| 梧州市| 河南省| 乌鲁木齐市| 苍溪县| 简阳市| 武平县| 民县| 文安县| 英吉沙县| 巧家县| 唐河县| 乌拉特中旗| 刚察县| 佛冈县| 龙江县| 台北县| 太仓市| 泸州市| 兰溪市| 宣武区| 彰武县| 秭归县| 辽阳市| 慈溪市| 平果县| 正定县| 温州市| 贵南县| 策勒县| 额济纳旗| 太康县| 东方市| 射阳县| 兴和县| 张家口市| 延庆县| 佛坪县| 卓尼县| 湛江市| 博罗县|