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.
| 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 | Check whether the DN corresponding to the current segment 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.
