lyp-bobi opened a new issue, #2140:
URL: https://github.com/apache/age/issues/2140
**Describe the bug**
A clear and concise description of what the bug is.
On my graph, the delete of vertex is extremely slow. So I use explain to
print its plan. However, the EXPLAIN takes nearly the same time of deletion.
**How are you accessing AGE (Command line, driver, etc.)?**
- [e.g. JDBC]
PostgreSQL 14, psql, AGE 1.5.0
**What data setup do we need to do?**
```pgsql
...
SELECT * from cypher('my_graph_name', $$
CREATE (a:Part {part_num: '123'}),
(b:Part {part_num: '345'}),
(c:Part {part_num: '456'}),
(d:Part {part_num: '789'})
$$) as (a agtype);
...
```
I guess you can reproduce it on any data.
**What is the necessary configuration info needed?**
- [e.g. Installed PostGIS]
**What is the command that caused the error?**
```pgsql
SELECT * from cypher('my_graph_name', $$
MATCH (a:Part {part_num: '123'}), (b:Part {part_num: '345'})
CREATE (a)-[u:used_by { quantity: 1 }]->(b)
$$) as (a agtype);
```
My SQL is:
```
explain SELECT *
FROM cypher('ldbc_graph', $$
MATCH (person:Person {id: 111})-[l:LIKES]->(post:Post {id: 222})
DELETE l
$$) AS (res1 agtype);
```
I pstack it and see it is working on
'end_cypher_delete->check_for_connected_edges'
**Expected behavior**
A clear and concise description of what you expected to happen.
**Environment (please complete the following information):**
- Version: [e.g. 0.4.0]
There's two major expectation:
1. The explaination of deletion should not use thank hook to delete the
connected edges.
2. The I have build btree index on (start_id, end_id) to accelerate my MATCH
cyphers. I guess it is also possible to delete the connected edges through that
index instead of scanning the full table?
**Additional context**
Add any other context about the problem here.
--
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.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
