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

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.

主站蜘蛛池模板: 讷河市| 无锡市| 平远县| 辽中县| 湖南省| 昭苏县| 姜堰市| 富蕴县| 同心县| 石嘴山市| 和龙市| 偃师市| 奉化市| 健康| 临澧县| 宁海县| 岑溪市| 天长市| 黑山县| 梁河县| 郸城县| 兴海县| 晋中市| 南投市| 宜宾县| 怀来县| 潮州市| 孝义市| 台南县| 巴彦淖尔市| 玛沁县| 沅陵县| 鄄城县| 东港市| 荃湾区| 贵州省| 布拖县| 武清区| 龙泉市| 广南县| 故城县|