gp_persistent_tablespace_node

gp_persistent_tablespace_node

The gp_persistent_tablespace_node table keeps track of the status of file
system objects in relation to the transaction status of tablespace 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

Table 1. pg_catalog.gp_persistent_tablespace_node

column

type

references

description

filespace_oid

oid

pg_filespace.oid

Filespace object id

tablespace_oid

oid

pg_tablespace.oid

Tablespace 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

mirror_existence_state

smallint

0 - none

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