PGXC_SLICE

PGXC_SLICE is a system catalog created for recording range distribution and list distribution details. Currently, range interval cannot be used to automatically scale out shards. It is reserved in the system catalog.

The PGXC_SLICE system catalog has specific meanings only in distributed scenarios. openGauss can only query the table definition.

Table 1 PGXC_SLICE columns

Name

Type

Description

relname

name

Table name or shard name, which is distinguished by type.

type

char

When the value is t, relname indicates the table name. When the value is s, relname indicates the shard name.

strategy

char

r: range distribution table

l: list distribution table

This value will be extended for subsequent interval shards.

relid

oid

OID of the distribution table to which the tuple belongs.

referenceoid

oid

OID of the referenced distribution table, which is used for slice reference table creation syntax.

sindex

int

Position of the current boundary in a shard when the table is a list distribution table.

interval

text[]

Reserved column

transitboundary

text[]

Reserved column

transitno

int

Reserved column

nodeoid

oid

When relname is set to a shard name, nodeoid indicates the OID of the DN where the shard data is stored.

boundaries

text[]

When relname is set to a shard name, this parameter indicates the boundary value of the shard.

specified

boolean

Whether the DN corresponding to the current segment is explicitly specified in the DDL.

sliceorder

int

User-defined shard sequence.

Feedback
编组 3备份
    openGauss 2024-04-24 00:46:07
    cancel