pdpotter commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-1109525588
Wow, this is fantastic. It is now possible to create relations quickly (~10
000/s on my local VM) using simple queries (with executemany) in the form of
```
SELECT * FROM cypher('graph_name', $$
MATCH (d:LabelA {id: 1}), (r:LabelB {id: 2})
CREATE (d)-[:Relation {prop: 'value'}]->(r)
$$) as (a agtype)
```
After simply adding GIN indexes
```
CREATE INDEX d:LabelA__properties
ON graph_name.LabelA USING GIN (properties)
```
```
CREATE INDEX d:LabelB__properties
ON graph_name.LabelB USING GIN (properties)
```
For this specific use case, it would of course be more disk space efficient
to only index the `id` property and not all of them, but having MATCH working
so much faster is a huge leap forward. Great work!
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
