PGXC_CLASS

PGXC_CLASS records the replicated or distributed information for each table.

Table 1 PGXC_CLASS columns

Column

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

Node group name

redistributed

Char

Whether a 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, which is a reserved column in the system