PGXC_CLASS

PGXC_CLASS records the replicated or distributed information for each table.

**Table 1** PGXC_CLASS columns
Name	Type	Description
pcrelid	oid	Table OID
pclocatortype	"char"	Locator type H: hash M: Modulo N: Round Robin R: Replicate
pchashalgorithm	smallint	Distributed tuple using the hash algorithm
pchashbuckets	smallint	Value of a harsh container
pgroup	name	Name of the node group
redistributed	"char"	The table has been redistributed.
redis_order	integer	Redistribution sequence
pcattnum	int2vector	Column number used as a distribution key
nodeoids	oidvector_extend	List of distributed table node OIDs
options	text	Extension status information. This is a reserved column in the system.

Parent topic: System Catalogs

Next Article: PGXC_GROUP

Did this article solve your problem?

Thank you for your score！Your feedback would help us improve the website.

Help Center