age icon indicating copy to clipboard operation
age copied to clipboard

Btree indexing in age

Open Yashmitha1 opened this issue 9 months ago • 2 comments

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 avatar May 20 '25 05:05 Yashmitha1

@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.

MuhammadTahaNaveed avatar May 23 '25 18:05 MuhammadTahaNaveed

@Yashmitha1 The same general command, except btree, and only on the id, start_id, and/or end_id columns.

jrgemignani avatar Sep 22 '25 21:09 jrgemignani