PGXC_CLASS
PGXC_CLASS records replicated or distributed information for each table.
Name |
Type |
Description |
---|---|---|
pcrelid |
oid |
OID of the table. |
pclocatortype |
"char" |
Locator type.
|
pchashalgorithm |
smallint |
Distributed tuple using the hash algorithm.
|
pchashbuckets |
smallint |
Value of a harsh container. |
pgroup |
name |
Name of a node cluster. |
redistributed |
"char" |
Indicates that a table has been redistributed. |
redis_order |
integer |
Redistribution sequence. Tables whose values are 0 will not be redistributed in this round of redistribution. |
pcattnum |
int2vector |
Column number used as a distributed key. |
nodeoids |
oidvector_extend |
List of distributed table node OIDs. |
options |
text |
Extension status information. This is a reserved column in the system. |
diskey |
text |
Character string of the distribution key expression in the brackets of the DISTRIBUTE BY clause in the SQL table creation statement. Currently, only MURMURHASH distribution is supported. |
diskeyexprs |
pg_node_tree |
Character string information obtained by serializing diskey by using the pack_node_to_string() function. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.