- 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.
推薦閱讀
- ABB工業(yè)機(jī)器人編程全集
- PostgreSQL 11 Server Side Programming Quick Start Guide
- ServiceNow Cookbook
- 返璞歸真:UNIX技術(shù)內(nèi)幕
- Visual C# 2008開(kāi)發(fā)技術(shù)詳解
- 最后一個(gè)人類
- 工業(yè)控制系統(tǒng)測(cè)試與評(píng)價(jià)技術(shù)
- Windows Server 2003系統(tǒng)安全管理
- Visual FoxPro程序設(shè)計(jì)
- 嵌入式GUI開(kāi)發(fā)設(shè)計(jì)
- Introduction to R for Business Intelligence
- 典型Hadoop云計(jì)算
- 電動(dòng)汽車驅(qū)動(dòng)與控制技術(shù)
- Microsoft Power BI Complete Reference
- 商務(wù)智能