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 |
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.