-
Type: Improvement
-
Status: Resolved
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: 5.6.0-HF15
-
Fix Version/s: 5.6.0-HF17, 5.7.1
-
Component/s: Core VCS
-
Environment:PostgreSQL
-
Tags:
Adding a gin index on the ancestors.ancestors field improve performance of NXQL query with the STARTSWITH operator.
CREATE INDEX ancestors_ancestors_idx ON ancestors USING gin(ancestors) WHERE ancestors;