- 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.
推薦閱讀
- 人工智能超越人類
- 蕩胸生層云:C語言開發(fā)修行實(shí)錄
- 精通Excel VBA
- Hands-On Machine Learning with TensorFlow.js
- 自動化控制工程設(shè)計(jì)
- 計(jì)算機(jī)網(wǎng)絡(luò)技術(shù)實(shí)訓(xùn)
- 運(yùn)動控制器與交流伺服系統(tǒng)的調(diào)試和應(yīng)用
- MATLAB/Simulink權(quán)威指南:開發(fā)環(huán)境、程序設(shè)計(jì)、系統(tǒng)仿真與案例實(shí)戰(zhàn)
- Learning Azure Cosmos DB
- MCGS嵌入版組態(tài)軟件應(yīng)用教程
- 基于企業(yè)網(wǎng)站的顧客感知服務(wù)質(zhì)量評價(jià)理論模型與實(shí)證研究
- Pentaho Analytics for MongoDB
- Linux系統(tǒng)管理員工具集
- MPC5554/5553微處理器揭秘
- 分布式Java應(yīng)用