ysvoon commented on issue #2198: URL: https://github.com/apache/age/issues/2198#issuecomment-3326320284
@jrgemignani That's good to hear, maybe it will improve the performance for our use case. I have tried **btree indexes** on the label (vertex) tables, but it seems like I am only able to create btree indexes on the `id` key only, not the `properties` (as I am creating the edges based on one of the id keys within `properties`). When I did `EXPLAIN ANALYZE`, it always shows that seq scan was being performed, which resulted in a much worse performance as compared to using **gin index** on `properties`, which we can see was using the index created. I also tried creating edges on the graph id instead of our custom key in `properties` with the btree index, but it was still performing sequential scans. I did not create index within the edge table's start_id and end_id, as I am trying to create edges within this table itself. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
