[Bitnine Tech] - It is not applied property index according to position of condition
- Dominant language
- C
- Stars
- 4.8k
- Forks
- 523
- Avg merge
- 1d 2h
- Merged PRs (30d)
- 9
Description
Hello, I'm Hyundong working in Bitnine, Korea.
When I execute SELECT clause with condition, It is not applied property index according to position of condition.
When the condition is located in WHERE clause, it doesn't work index scan, just full scan.
But when it is located in vertex, like photo, it works index scan.

I tested in this environment(256GB - server memory)
- shared_buffers = 64GB
- temp_buffers = 16GB
- work_mem = 512MB
- maintenance_work_mem = 8GB
I tested using queries like the bottom.
--------------------------
SELECT load_labels_from_file('test', 'comment', '~/ldbc_data/comment_1.csv');
CREATE INDEX test_comment_id_idx ON test.comment USING gin(properties);
SELECT * FROM cypher('test', $$ EXPLAIN ANALYZE MATCH (v:comment {content: 'thanks'}) RETURN v $$) AS (v agtype);
SELECT * FROM cypher('test', $$ EXPLAIN ANALYZE MATCH (v:comment) where v.content = 'thanks' RETURN v $$) AS (v agtype);
--------------------------
Using data file
[comment_1.csv](https://github.com/apache/age/files/10055295/comment_1.csv)
Contributor guide
Assessment
This issue has not been assessed yet.