The gp_persistent_relfile_node table keeps track of the status of file system objects in relation to the transaction status of database 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_relfile_node

column type references description
tablespaceoid oid pgtablespace.oid Tablespace object id
databaseoid oid pgdatabase.oid Database object id
relfilenodeoid oid pgclass.relfilenode The object id of the relation file node.
segmentfilenum integer    
relationstoragemanager smallint    
persistentstate 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

relationbufpoolkind integer    
parentxid integer   Global transaction id.
persistentserialnum bigint   Log sequence number position in the transaction log for a file block.
previousfreetid tid   Used by HAWQ to internally manage persistent representations of file system objects.