The gp_persistent_filespace_node table keeps track of the status of file system objects in relation to the transaction status of filespace objects. This information is used to make sure the state of the system catalogs and the file system files persisted to disk are synchronized. This information is used by the primary to mirror file replication process.

Table 1. pg_catalog.gp_persistent_filespace_node
column type references description
filespace_oid oid pg_filespace.oid object id of the filespace
db_id_1 smallint   primary segment id
location_1 text   primary filesystem location
db_id_2 smallint   mirror segment id
location_2 text   mirror filesystem location
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

mirror_existence _state smallint   0 - none

1 - not mirrored

2 - mirror create pending

3 - mirrorcreated

4 - mirror down before create

5 - mirror down during create

6 - mirror drop pending

7 - only mirror drop remains

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 Greenplum Database to internally manage persistent representations of file system objects.