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.
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 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot