These days noSQL databases quite popular, but knowing how an SQL database works at a pretty low level is not just a good idea, but a great idea. This document covers PostgreSQL in great detail.

PostgreSQL is an open source multi-purpose relational database system which is widely used throughout the world. It is one huge system with the integrated subsystems, each of which has a particular complex feature and works with each other cooperatively. Although understanding of the internal mechanism is crucial for both administration and integration using PostgreSQL, its hugeness and complexity prevent it. The main purposes of this document are to explain how each subsystem works, and to provide the whole picture of PostgreSQL.

Table Of Contents