pg_filespace_entry

A tablespace requires a file system location to store its database files. In HAWQ, the master and each segment needs its own distinct storage location. This collection of file system locations for all components in a HAWQ system is referred to as a filespace. The pg_filespace_entry table contains information about the collection of file system locations across a HAWQ system that comprise a HAWQ filespace.

Table 1. pg_catalog.pg_filespace_entry

columntypereferencesdescription
fsefsoidoidpgfilespace.oidObject id of the filespace.
fsedbidintegergp_segment configuration.dbidSegment id.
fselocationtext File system location for this segment id.