From the objective of OSS-DB Exam Gold
- Advanced Server Administration - Database architecture
Sample Question
1.10
Choose the one statement that is NOT an accurate description of the data stored in each subdirectory under the database cluster.
-
The "global" directory contains tables that are shared across the entire database cluster.
-
The "pg_tblspc" directory contains tables managed by tablespaces.
-
The "pg_xact" directory contains data related to transaction commit statuses.
-
The "pg_wal" directory contains WAL files.
-
The "pg_stat_tmp" directory contains temporary files used by the statistics collector to exchange information with backend processes.
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2025/05/29
Answer and Explanation
pg_tblspc does not directly contain data such as tables or indexes; instead, it contains symbolic links to tablespaces.
Tablespaces defined by users using the CREATE TABLESPACE command will have a symbolic link to the physical tablespace directory within pg_tblspc. The use of tablespaces allows data to be stored in a directory separate from the database cluster, enabling distribution of tables across multiple disk devices to improve I/O performance.
Other statements are correct.
Therefore, the correct answer is B.