What Is Tablespace?
A tablespace in PostgreSQL is a directory on disk where database objects like tables and indexes are stored. It allows for spreading data across multiple disks for performance or storage control.
Why It Matters for PostgreSQL Performance
In PostgreSQL performance work, Tablespace affects throughput, latency, or operational reliability depending on workload and configuration.
Practical Benchmarking Context
When benchmarking with pgbench, track how Tablespace changes behavior across scale factor, client concurrency, and storage conditions.
Use this term together with workload shape, concurrency level, and scale factor when interpreting pgbench outputs. Isolated values can be misleading without full run context.
Example
Command: CREATE TABLESPACE fast_disk LOCATION '/mnt/ssd';