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

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.

主站蜘蛛池模板: 历史| 天水市| 陆良县| 纳雍县| 石景山区| 达州市| 普洱| 溧阳市| 碌曲县| 山东| 樟树市| 高要市| 旺苍县| 道孚县| 旬邑县| 思茅市| 思茅市| 曲靖市| 三河市| 景东| 同江市| 宝山区| 满洲里市| 陇川县| 潮州市| 淮滨县| 敖汉旗| 清涧县| 孟津县| 和平区| 樟树市| 文安县| 哈密市| 英德市| 棋牌| 邵武市| 探索| 崇仁县| 双流县| 任丘市| 都昌县|