Documentation → PostgreSQL 8.2

Supported Versions: Current (17) / 16 / 15 / 14 / 13

Development Versions: devel

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

PostgreSQL 8.2.23 Documentation
Prev	Fast Backward		Fast Forward	Next

Chapter 12. Concurrency Control

Table of Contents

12.1. Introduction

12.2. Transaction Isolation

12.2.1. Read Committed Isolation Level
12.2.2. Serializable Isolation Level

12.3. Explicit Locking

12.3.1. Table-Level Locks
12.3.2. Row-Level Locks
12.3.3. Deadlocks
12.3.4. Advisory Locks

12.4. Data Consistency Checks at the Application Level

12.5. Locking and Indexes

This chapter describes the behavior of the PostgreSQL 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.

Prev	Home	Next
Examining Index Usage	Up	Introduction