rafsun42 commented on issue #982: URL: https://github.com/apache/age/issues/982#issuecomment-1765045565
@Zainab-Saad 1. Why does `parallel_tuple_cost` forces parallel scan? Why does PG automatically chose parallel scan for master, but not for label redesign? 2. Is label redesign slow because of `_ag_build_edge` function? I tried recreating the query- `(:Person)-[e:EDGE]->(:Title)` in SQL. Except, I used `SELECT * ..` instead of `SELECT _ag_build_edge( ...`. Hint: If you use VERBOSE with EXPLAIN, you will see what expression is projected by a plan node. The execution time was same before and after label redesign. Could you verify if that is the case? 3. Add index to make further better. Can we add index on start\end_label_id to make these queries faster? Additionally, should we do this performance tests after converting label ID columns into array? -- 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
