Postgresql - Tablespace & Advantages

PostgreSQL Tablespace :
Tablespace is an additional data space in PostgreSQL that is kept apart from the base directory. It is supported by PostgreSQL version 8.0. It allows file system locations for the files that represent database objects to be specified by database administrators. Once a tablespace is created, it can be referred to by name when creating database objects.

This has at least two advantages.

If the partition or volume on which the cluster was first formed runs out of space and cannot be extended, a tablespace can be created on a different partition and used until the system can be reconfigured.
Tablespaces enable an administrator to leverage their knowledge of database object usage patterns to optimize efficiency.

Next Topic » (Postgresql - pg_default, pg_global tablespaces)