age
age copied to clipboard
Btree indexing in age
How to create a btree index in age. I am able create gin index using : CREATE INDEX idx_test_attribute_instance_graph ON test_attribute_instance_graph."attribute_instance" USING gin (properties);
But for btree I couldn't find suitable syntax to be applied. I am using age v1.5 and postgresql ver 16.3
@Yashmitha1 You should take a look at this issue: https://github.com/apache/age/issues/2137. It includes some indexing strategies that might be helpful for you.
@Yashmitha1 The same general command, except btree, and only on the id, start_id, and/or end_id columns.