This diagram illustrates default tablespace and schema concepts – pg_default and pg_global are default tablespaces ; Template0 Vs Template1 – Default databases
- Postgres Terminology
This diagram illustrates default directories that gets created during installation and initialization;Postgres terminology – Database cluster Vs Database Vs Schema etc..
- Memory and Backend Processes
This diagram illustrates different memory areas in Postgres , backend process and more
- CTID and DB Page Layout
This diagram illustrates database page layout, CTID concepts ,Relfilenode and OID concepts