gp_persistent_filespace_node
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.
| 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 - free1 - 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 - none1 - 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.|
Parent topic: System Catalogs Definitions
