Course Content
ACID Properties and Query Processing
0/2
PostgreSQL Replication
0/1
PostgreSQL Upgrade
0/1
PostgreSQL Tutorial for Absolute Beginners [Administration]
About Lesson

PostgreSQL architecture

The above diagram shows that PostgreSQL architecture consists of 2 main sections. As of now, we leave the discussion of physical files and we discuss about physical files in detail during our physical database layout discussion.

  1. Process Architecture.
  2. Memory Architecture.

Process Architecture: PostgreSQL has the following 4 process types.

  1. Client process
  2. Backend/Server process.
  3. Background processes
  4. Postmaster process.