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