gp_persistent_database_node
The gp_persistent_database_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_database_node
| column | type | references | description |
|---|---|---|---|
tablespace_oid |
oid | pg_tablespace.oid | Table space object id. |
database_oid |
oid | pg_database.oid | Database 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. |