gp_persistent_relfile_node

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

columntypereferencesdescription
tablespace_oidoidpg_tablespace.oidTablespace object id
database_oidoidpg_database.oidDatabase object id
relfilenode_oidoidpg_class.relfilenodeThe object id of the relation file node.
segment_file_numinteger  
relation_storage_managersmallint  
persistent_statesmallint 0 - free

1 - create pending

2 - created

3 - drop pending

4 - aborting create

5 - “Just in Time” create pending

6 - bulk load create pending

relation_bufpool_kindinteger  
parent_xidinteger Global transaction id.
persistent_serial_numbigint Log sequence number position in the transaction log for a file block.
previous_free_tidtid Used by HAWQ to internally manage persistent representations of file system objects.