alteck45 opened a new issue, #1522:
URL: https://github.com/apache/age/issues/1522
We have been experimenting recently with Apache AGE specifically with the
main focus on performance in comparison to the standard Postgres DB.
Our very basic data model contains single vertex label `Acc
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
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
U
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 abov
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
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
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
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 i
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:Ac
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
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 messa
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
12 matches
Mail list logo