gp_distribution_policy

The gp_distribution_policy table contains information about Greengage DB tables and their policy for distributing table data across the segments. This table is populated only on the master. This table is not globally shared, meaning each database has its own copy of this table.

Column Type References Description

Column	Type	References	Description
localoid	oid	pg_class.oid	The table object identifier (OID)
policytype	char	—	The table distribution policy: `p` — partitioned policy; table data is distributed among segment instances. `r` — replicated policy; table data is replicated on each segment instance.
numsegments	integer	—	The number of segment instances on which the table data is distributed
distkey	int2vector	pg_attribute.attnum	The column number(s) of the distribution column(s)
distclass	oidvector	pg_opclass.oid	The operator class identifier(s) of the distribution column(s)

localoid

oid

pg_class.oid

The table object identifier (OID)

policytype

char

—

The table distribution policy:

p — partitioned policy; table data is distributed among segment instances.
r — replicated policy; table data is replicated on each segment instance.

numsegments

integer

—

The number of segment instances on which the table data is distributed

distkey

int2vector

pg_attribute.attnum

The column number(s) of the distribution column(s)

distclass

oidvector

pg_opclass.oid

The operator class identifier(s) of the distribution column(s)

gp_configuration_history

gp_fastsequence