PostgreSQL System Architecture

4 июля
Heikki Linnakangas

Software architecture means a high-level view of the components of the system and their relationships. Understanding how various components work together is crucial if you want to start hacking on PostgreSQL, but also for understanding performance characteristics and run-time behavior of production systems.

Software architecture is not a single diagram, but consists of multiple views of the same system.

  1. Process view: describing the processes at runtime and how they communicate.
  2. Data flow: how a query passes through various parts of the system, and how the results flow back.
  3. Data structures: how the Heap and Indexes are organized.
  4. Source code: what's in the PostgreSQL source treem, and many more.

In this presentation, I will give an overview of the most important views necessary to understand how PostgreSQL works.

Студентам – бесплатно!