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.
PGXC_SLICE can only be used to query table definitions in centralized mode.
Name | Type | Description |
|---|---|---|
relname | name | Table name or shard name, which is distinguished by type. |
type | "char" |
|
strategy | "char" |
This value will be extended for subsequent interval shards. |
relid | oid | OID of the distributed table to which the tuple belongs. |
referenceoid | oid | OID of the referenced distributed 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 distributed 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 | Specifies whether the DN corresponding to the current shard is explicitly specified in the DDL. |
sliceorder | integer | User-defined shard sequence. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
