• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PGXC_CLASS

PGXC_CLASS

PGXC_CLASS stores 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
  • 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 a node cluster

redistributed

"char"

Indicates that a table has been redistributed.

redis_order

integer

Redistribution sequence

pcattnum

int2vector

Column number used as a distributed key

nodeoids

oidvector

List of distributed table node OIDs