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

Adding snapshot too old

Those of you using Oracle would be aware of the following error message: snapshot too old. In Oracle, this message indicates that a transaction has been too long, so it has to be aborted. In PostgreSQL, transactions can run almost infinitely. However, long transactions can still be a problem, so the snapshot too old error has been added as a feature to 9.6, which allows transactions to be aborted after a certain amount of time.

The idea behind that is to prevent table bloat and to make sure that end users are aware of the fact that they might be about to do something stupid.

主站蜘蛛池模板: 惠来县| 九龙城区| 屏山县| 兴山县| 新乡市| 穆棱市| 六枝特区| 绥宁县| 景洪市| 美姑县| 怀化市| 成武县| 谷城县| 蛟河市| 安西县| 隆回县| 天祝| 五大连池市| 祁东县| 罗山县| 兰州市| 岱山县| 新民市| 江陵县| 台安县| 越西县| 得荣县| 深水埗区| 措勤县| 顺义区| 若羌县| 绥宁县| 库尔勒市| 修文县| 大石桥市| 高雄市| 绵竹市| 冀州市| 吉隆县| 基隆市| 吉首市|