HomeMogDBMogDB StackUqbar
v3.1

Documentation:v3.1

Supported Versions:

Other Versions:

PGXC_CLASS

PGXC_CLASS records the replicated or distributed information for each table. The PGXC_CLASS system catalog has specific meanings only in distributed scenarios. MogDB can only query the table definition.

Table 1 PGXC_CLASS columns

Name Type Description
pcrelid oid Table OID
pclocatortype “char” Locator type
- H: Hash
- G: Range
- L: List
- M: Modulo
- N: Round Robin
- R: Replication
pchashalgorithm smallint Distributed tuple using the hash algorithm
pchashbuckets smallint Value of a hash container
pgroup name Name of the node
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.
Copyright © 2011-2024 www.enmotech.com All rights reserved.