Help Center/ GaussDB/ Developer Guide(Distributed_2.x)/ System Catalogs and System Views/ System Catalogs/ PGXC_CLASS
Updated on 2023-10-23 GMT+08:00
View PDF
Share

PGXC_CLASS

PGXC_CLASS records replicated or distributed information for each table.

Table 1 PGXC_CLASS columns

Name

Type

Description

pcrelid

oid

OID of the table

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 harsh 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.
Parent topic: System Catalogs