Summary

In this chapter, you learned transactions, locking and its logical implications, and the general architecture the PostgreSQL transaction machinery can have for storage, concurrency, and administration. You saw how rows are locked and which features are available in PostgreSQL.

In Chapter 3, Making use of Indexes, you will learn one of the most important topics in database work: indexing. You will learn about the PostgreSQL query optimizer as well as various types of indexes and their behavior.