[PR] Make clean usage for Prepared Statements (clone pr#105) [age-website]

2025-08-29 Thread via GitHub
danny50610 opened a new pull request, #348: URL: https://github.com/apache/age-website/pull/348 Based on the tutorial First run this ``` PREPARE cypher_stored_procedure(agtype) AS SELECT * FROM cypher('expr', $$ MATCH (v:Person) WHERE v.name = $name RE

Re: [I] Performance Issue in Edge Creation for Large Tables and Index Creation [age]

2025-08-17 Thread via GitHub
ysvoon commented on issue #2198: URL: https://github.com/apache/age/issues/2198#issuecomment-3195166929 @jrgemignani Hello, haven't heard back in some time, just wanted to check if everything's okay and if you've managed to have a look at the above comments? :) -- This is an automated mes

Re: [I] Add Support for Apache AGE on Amazon RDS [age]

2025-08-16 Thread via GitHub
mkranjac commented on issue #998: URL: https://github.com/apache/age/issues/998#issuecomment-3193808629 +1 -- 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

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-08-15 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3192874888 @serdarmicrosoft After doing some research, I'm not sure we can improve this particular query any further with indexes. As it is using hash joins - > In PostgreSQL, a hash join

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-08-14 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3190070294 @serdarmicrosoft I removed the rest leaving - ``` psql-17.5-5432-pgsql=# select tablename,indexname,indexdef from pg_indexes where schemaname = 'goodreads_graph_x';

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-08-14 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3189979656 @serdarmicrosoft I removed the btree indexes on id for User, Book, Author, and Review. There wasn't any noticeable difference. -- This is an automated message from the Apache Git S

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-08-14 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3189729702 @serdarmicrosoft I removed the gin indexes on properties for User, Book, Author, and Review. It appears to have minimal (~1ms) impact. -- This is an automated message from the Apac

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-08-14 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3189495594 @serdarmicrosoft Unfortunately, no. agefreighter adds in indexes and it doesn't look like indexes can be removed. Or, at least that is my understanding. -- This is an automated

Re: [I] error while running Age-Viewer using : npm run start [age-viewer]

2025-08-14 Thread via GitHub
mstrYoda commented on issue #187: URL: https://github.com/apache/age-viewer/issues/187#issuecomment-3188899290 > > The first part i have solved installing babel/runtime by itself throught a command `npm install @babel/runtime` > > But the second i still have issues with, i don't know why

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-08-14 Thread via GitHub
serdarmicrosoft commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3187934958 @jrgemignani the results look amazing. Have you tried them with or without indexes? -- This is an automated message from the Apache Git Service. To respond to the message, plea

[I] docker image latest tag does not contain arm64 build [age]

2025-08-14 Thread via GitHub
mstrYoda opened a new issue, #2208: URL: https://github.com/apache/age/issues/2208 When I pull apache age from macOS machine it gives following error: WARNING: image with reference apache/age:latest was found but its platform (linux/amd64) does not match the specified platform (linux/

Re: [I] left() function fails to handle large negative integers correctly [age]

2025-08-13 Thread via GitHub
Phasheng closed issue #2205: left() function fails to handle large negative integers correctly URL: https://github.com/apache/age/issues/2205 -- 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 spec

Re: [I] Unexpected behavior when using empty string '' in string functions in Apache AGE [age]

2025-08-13 Thread via GitHub
Phasheng closed issue #2201: Unexpected behavior when using empty string '' in string functions in Apache AGE URL: https://github.com/apache/age/issues/2201 -- 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

Re: [I] left() function fails to handle large negative integers correctly [age]

2025-08-13 Thread via GitHub
jrgemignani commented on issue #2205: URL: https://github.com/apache/age/issues/2205#issuecomment-3185283924 @Phasheng PR #2207 corrects this issue. -- 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 t

Re: [I] Unexpected behavior when using empty string '' in string functions in Apache AGE [age]

2025-08-13 Thread via GitHub
jrgemignani commented on issue #2201: URL: https://github.com/apache/age/issues/2201#issuecomment-3185017863 This has been resolved. Please review and close the ticket. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use t

[I] left() function fails to handle large negative integers correctly [age]

2025-08-12 Thread via GitHub
Phasheng opened a new issue, #2205: URL: https://github.com/apache/age/issues/2205 **Describe the bug** I discovered that left() function incorrectly processes large negative integers below INT_MIN instead of throwing error. **How are you accessing AGE (Command line, driver, etc.)?

Re: [I] Unexpected behavior when using empty string '' in string functions in Apache AGE [age]

2025-08-12 Thread via GitHub
jrgemignani commented on issue #2201: URL: https://github.com/apache/age/issues/2201#issuecomment-3180847449 PR #2203 addresses this issue. -- 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 spe

Re: [I] Unexpected behavior when using empty string '' in string functions in Apache AGE [age]

2025-08-12 Thread via GitHub
MuhammadTahaNaveed commented on issue #2201: URL: https://github.com/apache/age/issues/2201#issuecomment-3180438704 > I think we should align this with Neo4j. Agreed. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and

Re: [I] Unexpected behavior when using empty string '' in string functions in Apache AGE [age]

2025-08-11 Thread via GitHub
jrgemignani commented on issue #2201: URL: https://github.com/apache/age/issues/2201#issuecomment-3177264268 @Phasheng AGE text functions are generally set up to return NULL on an empty string. I think we should align this with Neo4j. @MuhammadTahaNaveed thoughts? -- This is an aut

Re: [I] Unexpected behavior when using empty string '' in string functions in Apache AGE [age]

2025-08-11 Thread via GitHub
Phasheng closed issue #2202: Unexpected behavior when using empty string '' in string functions in Apache AGE URL: https://github.com/apache/age/issues/2202 -- 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

Re: [I] Unexpected behavior when using empty string '' in string functions in Apache AGE [age]

2025-08-10 Thread via GitHub
Phasheng closed issue #2202: Unexpected behavior when using empty string '' in string functions in Apache AGE URL: https://github.com/apache/age/issues/2202 -- 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

[I] Unexpected behavior when using empty string '' in string functions in Apache AGE [age]

2025-08-10 Thread via GitHub
Phasheng opened a new issue, #2201: URL: https://github.com/apache/age/issues/2201 **Describe the bug** I observed an unexpected behavior in Apache AGE when using empty strings ('') as arguments in string functions such as toLower. According to the documentation, toLower(NULL) returns NU

[I] Unexpected behavior when using empty string '' in string functions in Apache AGE [age]

2025-08-10 Thread via GitHub
Phasheng opened a new issue, #2202: URL: https://github.com/apache/age/issues/2202 **Describe the bug** I observed an unexpected behavior in Apache AGE when using empty strings ('') as arguments in string functions such as toLower. According to the documentation, toLower(NULL) returns NU

Re: [I] Performance Issue in Edge Creation for Large Tables and Index Creation [age]

2025-08-10 Thread via GitHub
ysvoon commented on issue #2198: URL: https://github.com/apache/age/issues/2198#issuecomment-3173234918 @jrgemignani Hi, while you are checking the above comments, may I additionally ask if the 1.6.0 release will be backward compatible? For e.g.: might we need major code changes should we u

[I] how to not generate subplan instead anti join [age]

2025-08-10 Thread via GitHub
AnnXie2001 opened a new issue, #2200: URL: https://github.com/apache/age/issues/2200 **Describe the bug** if we use not exists to find a path,the age will pass the query that cannot optimize to use anti join. So, when the table is large, the speed is so low. **How are you accessing

Re: [I] Performance Issue in Edge Creation for Large Tables and Index Creation [age]

2025-08-07 Thread via GitHub
jrgemignani commented on issue #2198: URL: https://github.com/apache/age/issues/2198#issuecomment-310908 @ysvoon No set date, unfortunately. I will try to look at what you posted above sometime tomorrow. -- This is an automated message from the Apache Git Service. To respond to the me

Re: [I] Performance Issue in Edge Creation for Large Tables and Index Creation [age]

2025-08-07 Thread via GitHub
ysvoon commented on issue #2198: URL: https://github.com/apache/age/issues/2198#issuecomment-3166587595 @jrgemignani I see, thank you for the information, is there a set date for the 1.6.0 release to be pushed out? Additionally, would like to ask if others been successful to use apach

Re: [I] Performance Issue in Edge Creation for Large Tables and Index Creation [age]

2025-08-07 Thread via GitHub
jrgemignani commented on issue #2198: URL: https://github.com/apache/age/issues/2198#issuecomment-3166548781 @ysvoon The set/merge issue #1907 was resolved but has not been released and is not part of 1.5.0. I am working on starting the release of 1.6.0 in the next few weeks. -- Th

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-08-07 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3166241750 @serdarmicrosoft PR #2199 adds additional variables that can have a huge impact on the performance of this query. Below I have added the output of explain analyze on my server for th

Re: [I] Performance Issue in Edge Creation for Large Tables and Index Creation [age]

2025-08-06 Thread via GitHub
ysvoon commented on issue #2198: URL: https://github.com/apache/age/issues/2198#issuecomment-3160397531 > This is due to the 2 MATCH commands used in creating the edges, as you are building your edges from the Person table; this is a O(n^2) operation. > > You might want to try the MER

[I] Default database connection [age-viewer]

2025-08-06 Thread via GitHub
iromanre opened a new issue, #188: URL: https://github.com/apache/age-viewer/issues/188 I think it would be very useful to be able to configure a default database connection. This way, when the service starts it will automatically connect to a previously configured database. This woul

Re: [I] Add Support for Apache AGE on Amazon RDS [age]

2025-08-06 Thread via GitHub
xplatsolutions commented on issue #998: URL: https://github.com/apache/age/issues/998#issuecomment-3159472301 +1 -- 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 unsubscr

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-08-06 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3157743632 @serdarmicrosoft I am working on a potential fix to this issue. My tests, so far, show nearly identical execution times between the two queries. -- This is an automated message fr

Re: [I] Performance Issue in Edge Creation for Large Tables and Index Creation [age]

2025-08-05 Thread via GitHub
jrgemignani commented on issue #2198: URL: https://github.com/apache/age/issues/2198#issuecomment-3155957266 > For vertex graph creation, this process was fairly fast, we only observe this performance issue with the edge creation process. This is due to the 2 MATCH commands used in cr

Re: [I] Performance Issue in Edge Creation for Large Tables and Index Creation [age]

2025-08-04 Thread via GitHub
ysvoon commented on issue #2198: URL: https://github.com/apache/age/issues/2198#issuecomment-3153047731 > [@ysvoon](https://github.com/ysvoon) What I can say about your query above is that it is not scalable for larger datasets; let me see if I can explain why,... > > Basically, what

Re: [I] Performance Issue in Edge Creation for Large Tables and Index Creation [age]

2025-08-04 Thread via GitHub
ysvoon commented on issue #2198: URL: https://github.com/apache/age/issues/2198#issuecomment-3153036994 > [@ysvoon](https://github.com/ysvoon) Could you provide the query plan? Also, are you increasing the size of Person? Meaning, adding in more people? > > For the query plan, use exp

Re: [I] Performance Issue in Edge Creation for Large Tables and Index Creation [age]

2025-08-04 Thread via GitHub
jrgemignani commented on issue #2198: URL: https://github.com/apache/age/issues/2198#issuecomment-3151463677 @ysvoon What I can say about your query above is that it is not scalable for larger datasets; let me see if I can explain why,... Basically, what you are asking, in pseudo cod

Re: [I] Performance Issue in Edge Creation for Large Tables and Index Creation [age]

2025-08-04 Thread via GitHub
jrgemignani commented on issue #2198: URL: https://github.com/apache/age/issues/2198#issuecomment-3151438436 @ysvoon Could you provide the query plan? -- 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

Re: [I] Performance issue when upserting 10k+ edges using MERGE [age]

2025-08-04 Thread via GitHub
ysvoon commented on issue #2177: URL: https://github.com/apache/age/issues/2177#issuecomment-3151140469 Hi @jrgemignani, I've created a separate issue with the sample query and what we've tried and the query plan here https://github.com/apache/age/issues/2198 -- This is an automated mess

Re: [I] Performance issue when upserting 10k+ edges using MERGE [age]

2025-08-04 Thread via GitHub
jrgemignani commented on issue #2177: URL: https://github.com/apache/age/issues/2177#issuecomment-3150971836 @ysvoon Could you provide your query and execution plan? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the

[I] Performance Issue in Edge Creation for Large Tables and Index Creation [age]

2025-08-04 Thread via GitHub
ysvoon opened a new issue, #2198: URL: https://github.com/apache/age/issues/2198 ### Questions: 1. How can I create index for graph tables? 2. How effective are they? I am using a gin index right now on properties, and I can see that the performance does improve for the initial 200k ed

Re: [I] Performance issue when upserting 10k+ edges using MERGE [age]

2025-08-04 Thread via GitHub
ysvoon commented on issue #2177: URL: https://github.com/apache/age/issues/2177#issuecomment-3149681581 Hi, doing something similar to this, we are using directed edges, and trying to create >8 million edges, and noticed this similar trend in performance, where after the approx 200k inserti

Re: [I] error while running Age-Viewer using : npm run start [age-viewer]

2025-08-02 Thread via GitHub
hamid-irannejad commented on issue #187: URL: https://github.com/apache/age-viewer/issues/187#issuecomment-3146420952 > The first part i have solved installing babel/runtime by itself throught a command `npm install @babel/runtime` > > But the second i still have issues with, i don't

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-08-01 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3145642720 @serdarmicrosoft Looking at the above I see something that could be contributing to the extra time needed to execute the cypher command - ``` ... Group Key: (age_id(_agty

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-08-01 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3145606964 @serdarmicrosoft I need to point out that these 2 commands are still not quite the same - ``` psql-17.5-5432-pgsql=# select count(*), u.id from goodreads_graph_x."User" u,

Re: [PR] Age setup additional docs (version alignment and tests). [age-website]

2025-08-01 Thread via GitHub
jccampagne closed pull request #332: Age setup additional docs (version alignment and tests). URL: https://github.com/apache/age-website/pull/332 -- 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

Re: [I] Add Support for Apache AGE on Amazon RDS [age]

2025-07-31 Thread via GitHub
jrgemignani commented on issue #998: URL: https://github.com/apache/age/issues/998#issuecomment-3141384219 @jayanthkmr AFAIK, this is totally up to Amazon. -- 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

Re: [I] Add Support for Apache AGE on Amazon RDS [age]

2025-07-31 Thread via GitHub
jayanthkmr commented on issue #998: URL: https://github.com/apache/age/issues/998#issuecomment-3141376533 Any update 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. T

Re: [I] Suggest integrating AGE as a 'Graph Store' in LlamaIndex for AI/RAG applications [age]

2025-07-31 Thread via GitHub
gab-gil commented on issue #1783: URL: https://github.com/apache/age/issues/1783#issuecomment-3139784713 +1 -- 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,

Re: [I] PostgreSQL 17 not supported [age]

2025-07-30 Thread via GitHub
jrgemignani commented on issue #2111: URL: https://github.com/apache/age/issues/2111#issuecomment-3138157374 @thomastthai PG 17 is on the **PG17** branch and is current with the **master**. So, if you want to use PG17.5 that branch should work for you. Currently, I have started workin

Re: [I] PostgreSQL 17 not supported [age]

2025-07-30 Thread via GitHub
thomastthai commented on issue #2111: URL: https://github.com/apache/age/issues/2111#issuecomment-3138153284 Which branch should I use if I want to run AGE with PostgreSQL 17.5? I saw the PG17 branch but wasn't sure. Master/main branch compiled and installed fine. I've not run tests on it y

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-07-30 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3136971875 @serdarmicrosoft I should note that the SQL command above references Book, so it is more comparable to the MATCH that does the same. -- This is an automated message from the Apache

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-07-30 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3136961271 @serdarmicrosoft @MuhammadTahaNaveed From my local system with the above graph loaded (PG17, CentOS 10)- **Graph statistics** ``` psql-17.5-5432-pgsql=# select * from cyp

Re: [I] error while running Age-Viewer using : npm run start [age-viewer]

2025-07-30 Thread via GitHub
iromanre commented on issue #187: URL: https://github.com/apache/age-viewer/issues/187#issuecomment-3135451132 The first part i have solved installing babel/runtime by itself throught a command `npm install @babel/runtime` But the second i still have issues with, i don't know why i

[I] AGE extension requires explicit commit after LOAD/SET for proper initialization in non-autocommit clients [age]

2025-07-28 Thread via GitHub
NathanInbar opened a new issue, #2195: URL: https://github.com/apache/age/issues/2195 **Is your feature request related to a problem? Please describe.** When using Apache AGE with database clients that do not default to autocommit (e.g., psycopg, JDBC), the extension requires an explicit

Re: [I] Add Support for Apache AGE on Amazon RDS [age]

2025-07-26 Thread via GitHub
THEPADA commented on issue #998: URL: https://github.com/apache/age/issues/998#issuecomment-3123675185 +1! -- 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

Re: [I] Why do you use Apache AGE? [age]

2025-07-26 Thread via GitHub
erhebend-tai commented on issue #1705: URL: https://github.com/apache/age/issues/1705#issuecomment-3123612984 Research and development for SQL -- 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

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-07-22 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3104168476 > I'm curious if it's possible to further optimize this, ideally getting its performance closer to the PostgreSQL equivalent, which runs the same query in only 3.6 seconds. @s

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-07-22 Thread via GitHub
serdarmicrosoft commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3104155140 Sorry @jrgemignani I missed your question. Here is the output of the queries: EXPLAIN select count(*), u.id from "User" u, "HAS_INTERACTION" h, "Book" b where u.id =

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-07-22 Thread via GitHub
serdarmicrosoft commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3104006972 Thanks @MuhammadTahaNaveed and @jrgemignani We were able to significantly improve the query's performance from 50 seconds down to 10 seconds just by modifying () to (:Book). I'm

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-07-22 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3102699847 Btw, that would also be true for `()-`, coming from any node and `-[]`, going through any edge. As each label is a table, you would want to restrict it where possible for better per

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-07-22 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3102666463 > That said, I believe AGE should ideally be smart enough to infer and apply such label constraints automatically to reduce unnecessary scans when label filters are present elsewhere

Re: [I] Add Support for Apache AGE on Amazon RDS [age]

2025-07-22 Thread via GitHub
dallasmarlow commented on issue #998: URL: https://github.com/apache/age/issues/998#issuecomment-3101521966 +1 -- 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 unsubscrib

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-07-21 Thread via GitHub
MuhammadTahaNaveed commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3098181976 @serdarmicrosoft In your SQL query, the tables are specified, but in Cypher query, the target label is not specified which causes age to scan all the vertex labels. **S

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-07-21 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3097359401 @serdarmicrosoft Could you add in the output of explain for this. Both for the sql and for the cypher - ``` EXPLAIN select count(*), u.id from "User" u, "HAS_INTERACTION" h,

Re: [I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-07-18 Thread via GitHub
jrgemignani commented on issue #2194: URL: https://github.com/apache/age/issues/2194#issuecomment-3089997721 @serdarmicrosoft It shouldn't run that slow, we will need to look into this. -- This is an automated message from the Apache Git Service. To respond to the message, please log on t

Re: [I] PostgreSQL 17 not supported [age]

2025-07-17 Thread via GitHub
jrgemignani commented on issue #2111: URL: https://github.com/apache/age/issues/2111#issuecomment-3085313759 @brecke I am working on it, just swamped with other tasks atm. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and u

Re: [I] PostgreSQL 17 not supported [age]

2025-07-17 Thread via GitHub
brecke commented on issue #2111: URL: https://github.com/apache/age/issues/2111#issuecomment-3083215268 any news on this front? I see there's a branch (behind master) PG17 and a docker-container, but it would be great to have a proper official release soon, if possible. Is there an ETA for

[I] Major Performance Difference: SQL vs. Cypher for Aggregation/Ordering [age]

2025-07-16 Thread via GitHub
serdarmicrosoft opened a new issue, #2194: URL: https://github.com/apache/age/issues/2194 I am executing a performance benchmarking for Apache AGE by using [goodreads dataset](https://cseweb.ucsd.edu/~jmcauley/datasets/goodreads.html). I've found a significant performance gap between a dire

Re: [PR] add missing column name to example query in advanced.md [age-website]

2025-07-14 Thread via GitHub
alxndr commented on PR #347: URL: https://github.com/apache/age-website/pull/347#issuecomment-3070187509 @jrgemignani I've just updated the PR description: > In the `Using Cypher with '='` section, the first example shows a result table with the columns "name" and "age", however the S

Re: [I] error while running Age-Viewer using : npm run start [age-viewer]

2025-07-12 Thread via GitHub
hamid-irannejad commented on issue #187: URL: https://github.com/apache/age-viewer/issues/187#issuecomment-3066645949 The below lines are also the remaining part of the error I got by running "npm run start" command. npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! ag-viewer-

[I] error while running Age-Viewer using : npm run start [age-viewer]

2025-07-12 Thread via GitHub
hamid-irannejad opened a new issue, #187: URL: https://github.com/apache/age-viewer/issues/187 I did > npm run setup and then > npm run start but I got the following errors: internal/modules/cjs/loader.js:883 throw err; ^ Error: Cannot find module '@babel/runt

Re: [I] create … with … The execution plan of match is abnormal [age]

2025-07-11 Thread via GitHub
jrgemignani commented on issue #2193: URL: https://github.com/apache/age/issues/2193#issuecomment-3062962971 @AnnXie2001 It will be looked into. Until it can be fixed, though, please use the **temporary** fix. -- This is an automated message from the Apache Git Service. To respond to the

Re: [I] create … with … The execution plan of match is abnormal [age]

2025-07-11 Thread via GitHub
AnnXie2001 commented on issue #2193: URL: https://github.com/apache/age/issues/2193#issuecomment-3060927666 In my inspection, I found that if it is the first creation, the execution plan of this statement will perform a join on an empty table, resulting in the return being null. I wonder if

Re: [I] create … with … The execution plan of match is abnormal [age]

2025-07-10 Thread via GitHub
jrgemignani commented on issue #2193: URL: https://github.com/apache/age/issues/2193#issuecomment-3058235296 @AnnXie2001 Verified in the master. It seems to happen with this command to any **new** label. While the command does not execute correctly the first time, it does create the new lab

Re: [I] Add Support for Apache AGE on Amazon RDS [age]

2025-07-10 Thread via GitHub
jrgemignani commented on issue #998: URL: https://github.com/apache/age/issues/998#issuecomment-3058018565 @rafsun42 -- 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 uns

Re: [I] Add Support for Apache AGE on Amazon RDS [age]

2025-07-09 Thread via GitHub
ramzimaalej commented on issue #998: URL: https://github.com/apache/age/issues/998#issuecomment-3053885728 +1 -- 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

Re: [I] Add Support for Apache AGE on Amazon RDS [age]

2025-07-09 Thread via GitHub
hadfield commented on issue #998: URL: https://github.com/apache/age/issues/998#issuecomment-3053273408 +1 -- 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 unsubscrib

[I] create … with … The execution plan of match is abnormal [age]

2025-07-09 Thread via GitHub
AnnXie2001 opened a new issue, #2193: URL: https://github.com/apache/age/issues/2193 **Describe the bug** create … with … The execution plan of match is abnormal. **How are you accessing AGE (Command line, driver, etc.)?** - Command line **What data setup do we need to

Re: [D] New Tag Post-1.5.0 to Include Recent Commits [age]

2025-06-23 Thread via GitHub
GitHub user serdarmicrosoft added a comment to the discussion: New Tag Post-1.5.0 to Include Recent Commits Great news @jrgemignani Appreciate the work being done to resolve the CI issue in PG17. Do you have an estimate on when the release might be ready? Thanks. GitHub link: https://github.

[I] Schema name should be configurable [age]

2025-06-18 Thread via GitHub
gwenshap opened a new issue, #2192: URL: https://github.com/apache/age/issues/2192 **Is your feature request related to a problem? Please describe.** Different companies have rules and standards about where they install extensions. As a result, most extensions support `CREATE EXTENSION

Re: [I] I have to add a line to Dockerfile make it work: RUN npm add @babel/runtime [age-viewer]

2025-06-12 Thread via GitHub
anvi233 commented on issue #185: URL: https://github.com/apache/age-viewer/issues/185#issuecomment-2966608789 Same problem, has this problem been solved now? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL abov

Re: [I] Performance issue [age]

2025-06-11 Thread via GitHub
xephtar commented on issue #2187: URL: https://github.com/apache/age/issues/2187#issuecomment-2965346631 Our graph is directed and connected, with relationships like A -> X or A -> Y. When we perform a directed search starting from node X, we can't reach its second-level neighbors by jumpin

Re: [I] Performance issue [age]

2025-06-11 Thread via GitHub
jrgemignani commented on issue #2187: URL: https://github.com/apache/age/issues/2187#issuecomment-2963306487 @xephtar Is there a reason that you need to match without direction **-[]-** ? That is, by far, one of the most resource intensive match patterns and basically negates the value of a

[I] Performance issue [age]

2025-06-11 Thread via GitHub
xephtar opened a new issue, #2187: URL: https://github.com/apache/age/issues/2187 ### 🔍 Performance Optimization for Multi-Hop Traversal in Apache AGE Context: We are currently using Apache AGE and have the following graph structure: ``` (:A)-[:HAS_Y]->(:Y) (:A)-[:H

Re: [I] Server crashes when executing SELECT * FROM cypher('list_comprehension' ...) [age]

2025-06-10 Thread via GitHub
jrgemignani closed issue #1850: Server crashes when executing SELECT * FROM cypher('list_comprehension' ...) URL: https://github.com/apache/age/issues/1850 -- 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

Re: [I] List comprehension as property constraint of MERGE clause errors out [age]

2025-06-10 Thread via GitHub
jrgemignani closed issue #1611: List comprehension as property constraint of MERGE clause errors out URL: https://github.com/apache/age/issues/1611 -- 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 th

Re: [I] List comprehensions [age]

2025-06-10 Thread via GitHub
jrgemignani closed issue #105: List comprehensions URL: https://github.com/apache/age/issues/105 -- 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-uns

Re: [PR] add missing column name to example query in advanced.md [age-website]

2025-06-10 Thread via GitHub
jrgemignani commented on PR #347: URL: https://github.com/apache/age-website/pull/347#issuecomment-2959596676 @alxndr Could you please explain more of what and why you are adding it? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to Gi

[PR] add missing column name to example query in advanced.md [age-website]

2025-06-09 Thread via GitHub
alxndr opened a new pull request, #347: URL: https://github.com/apache/age-website/pull/347 * add missing column name to `SELECT` * more consistent capitalization of query terms -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitH

Re: [I] PostgreSQL 17 not supported [age]

2025-06-09 Thread via GitHub
jrgemignani commented on issue #2111: URL: https://github.com/apache/age/issues/2111#issuecomment-2956086580 We were able to fix the CI issues with PG17. Now we need to apply this fix to the other branches. It looks like there were adjustments to privileges, on Github's side. For fut

Re: [I] Proposal: Vector handling with extension(pgvector) [age]

2025-06-07 Thread via GitHub
nicholasveloso commented on issue #1121: URL: https://github.com/apache/age/issues/1121#issuecomment-2952664670 > PRs [#2088](https://github.com/apache/age/pull/2088) and [#2172](https://github.com/apache/age/pull/2172) (in review) improve the interoperability of age with other extensions.

Re: [I] PostgreSQL 17 not supported [age]

2025-06-06 Thread via GitHub
jrgemignani commented on issue #2111: URL: https://github.com/apache/age/issues/2111#issuecomment-2951584851 @dianaoa22 We've been working on PG17 the past few days. Unfortunately, there have been issues with the CI that need to be fixed first. -- This is an automated message from the Apa

Re: [I] PostgreSQL 17 not supported [age]

2025-06-06 Thread via GitHub
dianaoa22 commented on issue #2111: URL: https://github.com/apache/age/issues/2111#issuecomment-2951358833 Is there an updated timeline for when Apache AGE will officially support PostgreSQL 17 in the 1.5.0 release? -- This is an automated message from the Apache Git Service. To respond t

Re: [D] New Tag Post-1.5.0 to Include Recent Commits [age]

2025-06-04 Thread via GitHub
GitHub user jrgemignani added a comment to the discussion: New Tag Post-1.5.0 to Include Recent Commits @serdarmicrosoft Just an update,... we're currently working on a CI issue in PG17 that is holding up getting it ready for a release. GitHub link: https://github.com/apache/age/discussions/

Re: [I] Add Support for Apache AGE on Amazon RDS [age]

2025-06-01 Thread via GitHub
LpKronek commented on issue #998: URL: https://github.com/apache/age/issues/998#issuecomment-2929055683 +1 -- 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

Re: [I] Ruby driver [age]

2025-05-31 Thread via GitHub
btihen commented on issue #370: URL: https://github.com/apache/age/issues/370#issuecomment-2925095603 # VERSION 0.7.0 - 2025-06-01 **Generic Queries** - ApacheAge::Node and ApacheAge::Edge can be used as the base for a query **Age Path** - nodes and edges combined (queries und

Re: [I] Add Support for Apache AGE on Amazon RDS [age]

2025-05-29 Thread via GitHub
miro-ur commented on issue #998: URL: https://github.com/apache/age/issues/998#issuecomment-2920466940 Interested in this as well -- 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 comm

Re: [I] Index advice for hop queries [age]

2025-05-28 Thread via GitHub
xephtar commented on issue #690: URL: https://github.com/apache/age/issues/690#issuecomment-2915895274 Hi, Years after initially optimizing this query in Neo4j, we're now considering moving back to Apache AGE. Our graph structure is as follows: A Label - HAS_Y -> Y Label A L

Re: [I] Error is reported when concurrently merging nodes/edges [age]

2025-05-27 Thread via GitHub
mdianjun commented on issue #2179: URL: https://github.com/apache/age/issues/2179#issuecomment-2911500398 I have fixed this issue in PR https://github.com/apache/age/pull/2178. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub a

  1   2   3   4   5   6   7   8   9   10   >