[GitHub] [incubator-age] JoshInnis commented on issue #45: unique properties / indexing

2022-05-09 Thread GitBox
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

[GitHub] [incubator-age] JoshInnis commented on issue #45: unique properties / indexing

2022-05-09 Thread GitBox
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

[GitHub] [incubator-age] JoshInnis commented on issue #45: unique properties / indexing

2022-04-25 Thread GitBox
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,

[GitHub] [incubator-age] JoshInnis commented on issue #45: unique properties / indexing

2022-04-24 Thread GitBox
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

[GitHub] [incubator-age] JoshInnis commented on issue #45: unique properties / indexing

2021-11-30 Thread GitBox
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. --

[GitHub] [incubator-age] JoshInnis commented on issue #45: unique properties / indexing

2021-11-30 Thread GitBox
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

[GitHub] [incubator-age] JoshInnis commented on issue #45: unique properties / indexing

2021-11-29 Thread GitBox
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