Postgres architecture diagram with explanation

Open source and very capable, PostgreSQL is an object-relational database system that builds upon the SQL language and incorporates numerous capabilities to securely store and handle even the most complex data demands. With almost 35 years of continuous development on the core platform, PostgreSQL began as part of the POSTGRES project at the University of California, Berkeley in 1986.


Process and Memory Architecture

To find the background process at OS level

bash-4.2$ ps -ef | grep postgres

postgres  1276     1  0 07:44 ?        00:00:00 /opt/PostgreSQL/10/bin/postgres -D /opt/PostgreSQL/10/data

postgres  1311  1276  0 07:44 ?        00:00:00 postgres: logger process

postgres  1335  1276  0 07:44 ?        00:00:00 postgres: checkpointer process

postgres  1336  1276  0 07:44 ?        00:00:00 postgres: writer process

postgres  1337  1276  0 07:44 ?        00:00:00 postgres: wal writer process

postgres  1338  1276  0 07:44 ?        00:00:00 postgres: autovacuum launcher process

postgres  1339  1276  0 07:44 ?        00:00:00 postgres: stats collector process

postgres  1342  1276  0 07:44 ?        00:00:00 postgres: bgworker: logical replication launcher

root      2522  2441  0 08:01 pts/0    00:00:00 su - postgres

postgres  2523  2522  0 08:01 pts/0    00:00:00 -bash

postgres  2688     1  0 08:11 ?        00:00:00 /usr/pgsql-14/bin/postgres -D /app01/cluster1

postgres  2689  2688  0 08:11 ?        00:00:00 postgres: logger

postgres  2691  2688  0 08:11 ?        00:00:00 postgres: checkpointer

postgres  2692  2688  0 08:11 ?        00:00:00 postgres: background writer

postgres  2693  2688  0 08:11 ?        00:00:00 postgres: walwriter

postgres  2694  2688  0 08:11 ?        00:00:00 postgres: autovacuum launcher

postgres  2695  2688  0 08:11 ?        00:00:00 postgres: stats collector

postgres  2696  2688  0 08:11 ?        00:00:00 postgres: logical replication launcher