On this page

Show all

Help Center/ GaussDB(DWS)/ Standard Data Warehouse (8.1.3.x)/ GaussDB(DWS) System Catalogs and Views/ System Catalogs/ PGXC_CLASS

PGXC_CLASS

Updated on 2023-10-31 GMT+08:00

View PDF

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

Previous topic: PG_WORKLOAD_ACTION

Next topic: PGXC_GROUP

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback