Re: [I] Apache AGE takes a long time to create graph node [age]

2024-05-18 Thread via GitHub
github-actions[bot] closed issue #1287: Apache AGE takes a long time to create graph node URL: https://github.com/apache/age/issues/1287 -- 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

Re: [I] Apache AGE takes a long time to create graph node [age]

2024-05-18 Thread via GitHub
github-actions[bot] commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-2119036173 This issue was closed because it has been stalled for further 7 days with no activity. -- This is an automated message from the Apache Git Service. To respond to the messag

Re: [I] Apache AGE takes a long time to create graph node [age]

2024-05-10 Thread via GitHub
github-actions[bot] commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-2105397138 This issue is stale because it has been open 45 days with no activity. Remove "Abondoned" label or comment or this will be closed in 7 days. -- This is an automated message

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-11-27 Thread via GitHub
I33Buckler commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1829271971 > @I33Buckler Currently, AGE tables are paritioned by their label name. Further partitoning a label's table may be useful. It may speed up (some) MATCH queries more than CREATE querie

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-11-27 Thread via GitHub
rafsun42 commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1828303759 @I33Buckler Currently, AGE tables are paritioned by their label name. Further partitoning a label's table may be useful. It may speed up (some) MATCH queries more than CREATE queries, i

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-11-24 Thread via GitHub
I33Buckler commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1826127392 > @I33Buckler > > > I have done this to the table AllServices.Stop_Times > > Could you please elaborate how you did the partitioning? Is `AllServices.Stop_Times` an AGE t

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-11-21 Thread via GitHub
rafsun42 commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1821790428 @I33Buckler > I have done this to the table AllServices.Stop_Times Could you please elaborate how you did the partitioning? Is `AllServices.Stop_Times` an AGE table? --

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-11-20 Thread via GitHub
jrgemignani commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1819601299 @rafsun42 Thoughts? -- 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 comme

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-11-14 Thread via GitHub
I33Buckler commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1809983914 > > [@jrgemignani ](https://github.com/jrgemignani) Is it possible or are there plans to enable partitioning a graph node? That would help greatly with processing. At the moment the o

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-11-13 Thread via GitHub
jrgemignani commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1808765845 > [@jrgemignani ](https://github.com/jrgemignani) Is it possible or are there plans to enable partitioning a graph node? That would help greatly with processing. At the moment the on

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-11-11 Thread via GitHub
I33Buckler commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1806939597 [@jrgemignani ](https://github.com/jrgemignani) Is it possible or are there plans to enable partitioning a graph node? That would help greatly with processing. At the moment the on

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-11-10 Thread via GitHub
I33Buckler commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1805479688 > @I33Buckler I'd be careful with StackOverflow answers that have few, if any, responses. That one, in particular, is not very helpful in my opinion. > Thanks. I referred to

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-11-09 Thread via GitHub
jrgemignani commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1804706376 @I33Buckler I'd be careful with StackOverflow answers that have few, if any, responses. That one, in particular, is not very helpful in my opinion. I feel the following **might

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-11-03 Thread via GitHub
I33Buckler commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1793277565 > @I33Buckler If you are using that function, with the **O(N^3)** runtime, or greater, I wouldn't wait as it could take a very long time. You need to find a way to write a more effici

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-11-03 Thread via GitHub
jrgemignani commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1793242535 @I33Buckler If you are using that function, with the **O(N^3)** runtime, or greater, I wouldn't wait as it could take a very long time. You need to find a way to write a more efficie

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-11-02 Thread via GitHub
I33Buckler commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1790316796 > @I33Buckler If there is a cypher command causing a crash, or failing, we can try to look into that but, we will need more information about what is crashing or failing. The log info

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-10-30 Thread via GitHub
jrgemignani commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1785698446 @I33Buckler If there is a cypher command causing a crash, or failing, we can try to look into that but, we will need more information about what is crashing or failing. The log infor

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-10-28 Thread via GitHub
I33Buckler commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1783935480 A factor that I've noticed with regard to the noticeable performance difference between joining the PostgreSQL tables in the database and and joining the nodes is the difference in es

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-10-27 Thread via GitHub
I33Buckler commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1783638830 > @I33Buckler Your `create_stop_times` function is **O(N^3)** and that is inside a doubly nested loop that also does **SELECT**s from tables for each level. This can lead to as much a

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-10-25 Thread via GitHub
jrgemignani commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1779709262 @I33Buckler Your `create_stop_times` function is **O(N^3)** and that is inside a doubly nested loop that also does **SELECT**s from tables for each level. This can lead to as much as

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-10-25 Thread via GitHub
I33Buckler commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1779281110 > @I33Buckler AGE has utilities to load graph from CSV. Can it be used instead of plpgsql functions? https://age.apache.org/age-manual/master/intro/agload.html > Rather limitin

Re: [I] Apache AGE takes a long time to create graph node [age]

2023-10-24 Thread via GitHub
rafsun42 commented on issue #1287: URL: https://github.com/apache/age/issues/1287#issuecomment-1777664476 @I33Buckler AGE has utilities to load graph from CSV. Can it be used instead of plpgsql functions? https://age.apache.org/age-manual/master/intro/agload.html Also, are you usi

[I] Apache AGE takes a long time to create graph node [age]

2023-10-24 Thread via GitHub
I33Buckler opened a new issue, #1287: URL: https://github.com/apache/age/issues/1287 I am in the process of creating a graph node from a database table that has 7.6 million lines. The process runs a function to process the table into the graph with loops. Initial run of the process i