Summary

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

In the next chapter, 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 index and their behavior.