- Mastering PostgreSQL 9.6
- Hans Jurgen Schonig
- 110字
- 2021-07-09 19:57:11
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.
推薦閱讀
- 大數(shù)據(jù)管理系統(tǒng)
- 21天學(xué)通JavaScript
- Learning Microsoft Azure Storage
- 返璞歸真:UNIX技術(shù)內(nèi)幕
- 網(wǎng)絡(luò)組建與互聯(lián)
- 內(nèi)模控制及其應(yīng)用
- Mastering Text Mining with R
- 電氣控制及Micro800 PLC程序設(shè)計
- PyTorch深度學(xué)習(xí)
- 暗戰(zhàn)強人:黑客攻防入門全程圖解
- OSGi原理與最佳實踐
- 自動化生產(chǎn)線組建與調(diào)試(第2版):以亞龍YL-335B為例(三菱PLC版本)
- Deployment with Docker
- R Programming By Example
- 喬家大院里的女人與Photoshop創(chuàng)意設(shè)計