posted Jan 19, 2014, 5:35 PM by Sachchida Ojha   [ updated Jan 19, 2014, 5:36 PM ]

gpadmin=# \d gp_distribution_policy

Table "pg_catalog.gp_distribution_policy"

Column | Type | Modifiers
localoid | oid | not null
attrnums | smallint[] | 
"gp_policy_localoid_index" UNIQUE, btree (localoid)

The gp_distribution_policy table contains information about Greenplum Database 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.