vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_04_0633.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

8.2 KiB
Raw Permalink Blame History

PGXC_CLASS

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