Zainab-Saad commented on issue #1004:
URL: https://github.com/apache/age/issues/1004#issuecomment-1692304284
Create edge table as a RANGE partitioned table using for instance start
label id
```
CREATE TABLE graph_name._ag_label_egde (
id int64,
start_id int64,
end_id int64,
properties agtype,
start_label_id int32,
end_label_id int32,
label_id int32
) PARTITION BY RANGE (start_label_id)
```
Then the partitions (as more labels are added) can be created as
```
CREATE TABLE _ag_label_edge_1 PARTITION OF graph_name._ag_label_edge
FOR VALUES FROM (1) TO (5);
CREATE TABLE _ag_label_edge_2 PARTITION OF graph_name._ag_label_edge
FOR VALUES FROM (5) TO (10);
```
[reference](https://www.postgresql.org/docs/current/ddl-partitioning.html)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@age.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
