gp_persistent_filespace_node

posted Jan 19, 2014, 6:05 PM by Sachchida Ojha
gpadmin=# \d gp_persistent_filespace_node

Table "pg_catalog.gp_persistent_filespace_node"
Column | Type | Modifiers 
----------------------------------------------+----------+-----------
filespace_oid | oid | not null
db_id_1 | smallint | not null
location_1 | text | 
db_id_2 | smallint | 
location_2 | text | 
persistent_state | smallint | 
create_mirror_data_loss_tracking_session_num | bigint | 
mirror_existence_state | smallint | 
reserved | integer | 
parent_xid | integer | 
persistent_serial_num | bigint | 
previous_free_tid | tid | 

Tablespace: "pg_global"

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.
Comments