gp_persistent_relation_node

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

Table "pg_catalog.gp_persistent_relation_node"
Column | Type | Modifiers 
---------------------------------------------------+-----------+-----------
tablespace_oid | oid | not null
database_oid | oid | not null
relfilenode_oid | oid | not null
segment_file_num | integer | not null
relation_storage_manager | smallint | not null
persistent_state | smallint | not null
create_mirror_data_loss_tracking_session_num | bigint | not null
mirror_existence_state | smallint | not null
mirror_data_synchronization_state | smallint | not null
mirror_bufpool_marked_for_scan_incremental_resync | boolean | not null
mirror_bufpool_resync_changed_page_count | bigint | not null
mirror_bufpool_resync_ckpt_loc | gpxlogloc | not null
mirror_bufpool_resync_ckpt_block_num | integer | not null
mirror_append_only_loss_eof | bigint | not null
mirror_append_only_new_eof | bigint | not null
relation_bufpool_kind | integer | not null
parent_xid | integer | not null
persistent_serial_num | bigint | not null
previous_free_tid | tid | not null

Tablespace: "pg_global"

The gp_persistent_relation_node table table keeps track of the status of file system objects in relation to the transaction status of relation objects (tables, view, indexes, and so on). 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