Skip to main content

If you like Apache Cloudberry (Incubating), give it a star on GitHub!

Version: Next

gp_distribution_policy

The gp_distribution_policy table in the pg_catalog schema contains information about Apache Cloudberry tables and their policy for distributing table data across the segments. This table is populated only on the coordinator. This table is not globally shared, meaning each database has its own copy of this table.

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

Support

GitHub Discussions

Resources

Brand Guidelines

Contribution

Working with Git & GitHub

Contribution Overview

Code Contribution

Doc Contribution

Apache Cloudberry is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.

Copyright © 2025 The Apache Software Foundation, Licensed under the Apache License, Version 2.0.

Apache®, the names of Apache projects, and the feather logo are either registered trademarks or trademarks of the Apache Software Foundation in the United States and/or other countries.