apache / apache/age

[Bitnine Tech] - It is not applied property index according to position of condition

Open
#359 4 comments 0 reactions 0 assignees View on GitHub
bug
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.
![8e45aefe-37d1-4fa8-b9a5-cf7143cfdc0e](https://user-images.githubusercontent.com/77366371/203007927-837b1eaf-0c2e-4afb-9362-cec49e38594b.png)

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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.