文件操作 - mvcc.html
返回文件管理
返回主菜单
删除本文件
文件: /usr/share/doc/postgresql-9.2.24/html/mvcc.html
编辑文件内容
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >Concurrency Control</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 9.2.24 Documentation" HREF="index.html"><LINK REL="UP" TITLE="The SQL Language" HREF="sql.html"><LINK REL="PREVIOUS" TITLE="Migration from Pre-8.3 Text Search" HREF="textsearch-migration.html"><LINK REL="NEXT" TITLE="Introduction" HREF="mvcc-intro.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="stylesheet.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" CONTENT="2017-11-06T22:43:11"></HEAD ><BODY CLASS="CHAPTER" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="5" ALIGN="center" VALIGN="bottom" ><A HREF="index.html" >PostgreSQL 9.2.24 Documentation</A ></TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A TITLE="Migration from Pre-8.3 Text Search" HREF="textsearch-migration.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="sql.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="60%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="20%" ALIGN="right" VALIGN="top" ><A TITLE="Introduction" HREF="mvcc-intro.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="CHAPTER" ><H1 ><A NAME="MVCC" ></A >Chapter 13. Concurrency Control</H1 ><DIV CLASS="TOC" ><DL ><DT ><B >Table of Contents</B ></DT ><DT >13.1. <A HREF="mvcc-intro.html" >Introduction</A ></DT ><DT >13.2. <A HREF="transaction-iso.html" >Transaction Isolation</A ></DT ><DD ><DL ><DT >13.2.1. <A HREF="transaction-iso.html#XACT-READ-COMMITTED" >Read Committed Isolation Level</A ></DT ><DT >13.2.2. <A HREF="transaction-iso.html#XACT-REPEATABLE-READ" >Repeatable Read Isolation Level</A ></DT ><DT >13.2.3. <A HREF="transaction-iso.html#XACT-SERIALIZABLE" >Serializable Isolation Level</A ></DT ></DL ></DD ><DT >13.3. <A HREF="explicit-locking.html" >Explicit Locking</A ></DT ><DD ><DL ><DT >13.3.1. <A HREF="explicit-locking.html#LOCKING-TABLES" >Table-level Locks</A ></DT ><DT >13.3.2. <A HREF="explicit-locking.html#LOCKING-ROWS" >Row-level Locks</A ></DT ><DT >13.3.3. <A HREF="explicit-locking.html#LOCKING-DEADLOCKS" >Deadlocks</A ></DT ><DT >13.3.4. <A HREF="explicit-locking.html#ADVISORY-LOCKS" >Advisory Locks</A ></DT ></DL ></DD ><DT >13.4. <A HREF="applevel-consistency.html" >Data Consistency Checks at the Application Level</A ></DT ><DD ><DL ><DT >13.4.1. <A HREF="applevel-consistency.html#SERIALIZABLE-CONSISTENCY" >Enforcing Consistency With Serializable Transactions</A ></DT ><DT >13.4.2. <A HREF="applevel-consistency.html#NON-SERIALIZABLE-CONSISTENCY" >Enforcing Consistency With Explicit Blocking Locks</A ></DT ></DL ></DD ><DT >13.5. <A HREF="mvcc-caveats.html" >Caveats</A ></DT ><DT >13.6. <A HREF="locking-indexes.html" >Locking and Indexes</A ></DT ></DL ></DIV ><P > This chapter describes the behavior of the <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN > database system when two or more sessions try to access the same data at the same time. The goals in that situation are to allow efficient access for all sessions while maintaining strict data integrity. Every developer of database applications should be familiar with the topics covered in this chapter. </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="textsearch-migration.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="mvcc-intro.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Migration from Pre-8.3 Text Search</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="sql.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Introduction</TD ></TR ></TABLE ></DIV ></BODY ></HTML >
修改文件时间
将文件时间修改为当前时间的前一年
删除文件