Re: [I] Sorted queries do not utilise indices, when such are introduced [age]
github-actions[bot] closed issue #1522: Sorted queries do not utilise indices, when such are introduced URL: https://github.com/apache/age/issues/1522 -- 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
Re: [I] Sorted queries do not utilise indices, when such are introduced [age]
github-actions[bot] commented on issue #1522: URL: https://github.com/apache/age/issues/1522#issuecomment-2143638874 This issue was closed because it has been stalled for further 14 days with no activity. -- 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
Re: [I] Sorted queries do not utilise indices, when such are introduced [age]
github-actions[bot] commented on issue #1522: URL: https://github.com/apache/age/issues/1522#issuecomment-2119036119 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 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
Re: [I] Sorted queries do not utilise indices, when such are introduced [age]
sir-sa commented on issue #1522: URL: https://github.com/apache/age/issues/1522#issuecomment-2033535189 --Cypher query: Retriev all AccessPoint vertices ordered by id, utilizing BTREE index on vertex id- SELECT * FROM cypher( 'test-graph', $$ MATCH (ap:AccessPoint) WITH ap ORDER BY id(ap) RETURN ap $$ ) as (value agtype); -- 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
Re: [I] Sorted queries do not utilise indices, when such are introduced [age]
jrgemignani commented on issue #1522: URL: https://github.com/apache/age/issues/1522#issuecomment-1960352971 @alteck45 I'm not sure why it is expanding the query out with `ap.id` and `ap.properties`. I have a feeling this is not allowing some of the indexes to work. I will look at the GIN indexes next. ``` psql-16.1-5432-pgsql=# SELECT * FROM cypher( 'test-graph', $$ EXPLAIN MATCH (ap:AccessPoint) RETURN ap ORDER BY id(ap) $$) as (value agtype); QUERY PLAN -- Subquery Scan on _ (cost=1.49..1.64 rows=12 width=32) -> Sort (cost=1.49..1.52 rows=12 width=64) Sort Key: (age_id(_agtype_build_vertex(ap.id, _label_name('16979'::oid, ap.id), ap.properties))) -> Seq Scan on "AccessPoint" ap (cost=0.00..1.27 rows=12 width=64) (4 rows) psql-16.1-5432-pgsql=# ``` -- 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
Re: [I] Sorted queries do not utilise indices, when such are introduced [age]
jrgemignani commented on issue #1522: URL: https://github.com/apache/age/issues/1522#issuecomment-1958485554 @alteck45 I'm also a bit confused by `ap.id` what `id` are you referring to or expecting? An `id` that **you** set in the properties or the `id` of the vertex that is generated when the vertex is created? -- 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
Re: [I] Sorted queries do not utilise indices, when such are introduced [age]
jrgemignani commented on issue #1522: URL: https://github.com/apache/age/issues/1522#issuecomment-1958474851 @alteck45 This index won't be used - `CREATE UNIQUE INDEX ap_id ON "test-graph"."AccessPoint" USING btree (agtype_access_operator(properties, '"id"'));` due to the query not matching `agtype_access_operator(properties, '"id"')` - ``` (agtype_access_operator(VARIADIC ARRAY[_agtype_build_vertex(ap.id, _label_name('20505'::oid, ap.id), ap.properties), '""id""'::agtype])) ``` -- 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
Re: [I] Sorted queries do not utilise indices, when such are introduced [age]
jrgemignani commented on issue #1522: URL: https://github.com/apache/age/issues/1522#issuecomment-1958148200 @alteck45 Could you provide a simple sample set so that we can try to reproduce this? -- 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
Re: [I] Sorted queries do not utilise indices, when such are introduced [age]
jrgemignani commented on issue #1522: URL: https://github.com/apache/age/issues/1522#issuecomment-1912891494 @alteck45 Could you provide a simple sample set? -- 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
Re: [I] Sorted queries do not utilise indices, when such are introduced [age]
alteck45 commented on issue #1522: URL: https://github.com/apache/age/issues/1522#issuecomment-1911645755 @jrgemignani PostgreSQL version 16.1 and AGE version 1.5.0 -- 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
Re: [I] Sorted queries do not utilise indices, when such are introduced [age]
jrgemignani commented on issue #1522: URL: https://github.com/apache/age/issues/1522#issuecomment-1910732993 @alteck45 What version of PostgreSQL and version of AGE are you running this on? Additionally, these 2 issues covered a lot about indexes, albeit with WHERE, that might be of assistance. #1235 #1000 -- 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