Updated on 2025-08-25 GMT+08:00

PGXC_CLASS

PGXC_CLASS stores replication or distribution information for each table.

Table 1 PGXC_CLASS columns

Column

Type

Description

pcrelid

oid

OID of a table.

pclocatortype

"char"

Locator type. Options:

  • H: hash.
  • M: Modulo.
  • N: Round Robin.
  • R: Replicate.

pchashalgorithm

smallint

Uses the hash algorithm to distribute tuples.

pchashbuckets

smallint

Value of the hash bucket.

pgroup

name

Name of the node group.

redistributed

"char"

Table has been redistributed.

redis_order

integer

Order of redistribution.

pcattnum

int2vector

Column numbers used as the distribution key.

nodeoids

oidvector_extend

List of OIDs of nodes where the table is distributed.

options

text

Reserved column within the system, storing extended state information.