Updated on 2024-05-07 GMT+08:00

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.

In the centralized system, only the definition of this table can be queried.

Table 1 PGXC_SLICE columns

Name

Type

Description

relname

name

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

type

"char"

  • 't': relname is the table name.
  • 's': relname is 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

integer

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

integer

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

integer

User-defined shard sequence.