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

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.

主站蜘蛛池模板: 霍山县| 丁青县| 常宁市| 玉屏| 合江县| 万宁市| 芦溪县| 西乡县| 佳木斯市| 河北省| 陵川县| 阿合奇县| 大邑县| 华阴市| 陇川县| 勃利县| 雅安市| 凤翔县| 铁力市| 红安县| 滁州市| 池州市| 上饶县| 荔浦县| 青海省| 古田县| 信阳市| 资兴市| 雷波县| 乌拉特前旗| 巴南区| 汉阴县| 洞头县| 丹阳市| 泾源县| 汝南县| 漠河县| 西吉县| 上高县| 瓦房店市| 大化|