Postgres Tablespaces

By default, PostgreSQL cluster datafiles, configuration files, and transaction log files are stored in the operating system directory and refer to the environmental PGDATA, which is located in the operating system root directory. Tables and other objects are created within this directory, which is referred to as the default data directory. With the creation of PostgreSQL tablespaces, you can distribute table and index data into separate tablespaces residing at different disk locations to take advantage of parallel I/O on multiple drives. Furthermore, you can define different schemas residing at separate storage locations for effective balancing of I/O to improve overall performance. The PostgreSQL cluster includes the backup of files residing on file systems along with the backup of the PGDATA directory