gp_persistent_tablespace_node

The gp_persistent_tablespace_node table keeps track of the status of file system objects in relation to the transaction status of tablespace objects. This information is used to make sure the state of the system catalogs and the file system files persisted to disk are synchronized.

Table 1. pg_catalog.gp_persistent_tablespace_node

column

type

references

description

filespace_oid

oid

pg_filespace.oid

Filespace object id

tablespace_oid

oid

pg_tablespace.oid

Tablespace object id

persistent_state

smallint

0 - free

1 - create pending

2 - created

3 - drop pending

4 - aborting create

5 - “Just in Time” create pending

6 - bulk load create pending

parent_xid

integer

Global transaction id.

persistent_serial_num

bigint

Log sequence number position in the transaction log for a file block.

previous_free_tid

tid

Used by HAWQ to internally manage persistent representations of file system objects.