JoshInnis commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-1121506054
For an article about this you can checkout this
https://bitnine.net/blog-postgresql/postgresql-internals-jsonb-type-and-its-indexes/
Its a bit dated and about Agensgraph and not
JoshInnis commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-1121493128
Hi @pdpotter, GIN Indices are for a subset of JsonB operators
https://www.postgresql.org/docs/11/gin-builtin-opclasses.html These operators
are not usabale in the cypher Where
JoshInnis commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-1108977096
Hi @pdpotter, sorry for the confusion, AGE now supports constraints, the
MATCH clause does not yet support using index scans. Constraints now work and
the updating (SET, REMOVE,
JoshInnis commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-1107919956
Hello, the commit
https://github.com/apache/incubator-age/commit/57e11a3e6952d0dcfa50de3b92e07fb596df68b0
in master should have resolved this issue and will be available in the
JoshInnis commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-983105857
Indices cannot currently be used while matching. There will need to be some
re factoring done to allow the planner to realize opportunities where the
indices can be used.
--
JoshInnis commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-98308
It might be safe to change `agtype_access_operator` to immutable.
Per Postgres' Documentation:
IMMUTABLE indicates that the function cannot modify the database and
JoshInnis commented on issue #45:
URL: https://github.com/apache/incubator-age/issues/45#issuecomment-982285644
Hello,
A schema is a graph name and a label is a table name. Id and properties
field are columns in vertices and id, start_id, end_id, and properties are
columns in the