PostgreSQL 10 High Performance - Third Edition

Database directory tree

With this background in mind, here are the major directories inside the PostgreSQL database structure that initdb creates:

• base: This is the location that holds pg_default, the default tablespace. The template databases and any additional ones created without an explicit tablespace assignment will all be placed here. The next chapter, Chapter 5, Memory for Database Caching, digs into the details of how the directory is organized into databases and tables.
• global: Holds the pg_global virtual tablespace. This is where system tables shared by all databases in a cluster, such as the database roles and other system catalog data, are stored.
• pg_xact: The transaction commit log data is stored here. This data is actively ...