gp_persistent_relation_node

Post date: Jan 20, 2014 2:8:23 AM

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.