- Notifications
You must be signed in to change notification settings - Fork6
Pm 2206 2nd fix#51
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.
Already on GitHub?Sign in to your account
Uh oh!
There was an error while loading.Please reload this page.
Conversation
0a4a03f intodevelopUh oh!
There was an error while loading.Please reload this page.
| @@ -0,0 +1,4 @@ | |||
| -- Improve search responsiveness for group-constrained queries | |||
| CREATEINDEXIF NOT EXISTS"challenge_groups_gin_idx" | |||
| ON"challenges"."Challenge" | |||
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others.Learn more.
[❗❗correctness]
Ensure that thegroups column is of a type that supports GIN indexing, such asjsonb or an array type. If it is not, the index may not function as intended.
| @@index([updatedAt]) | ||
| @@index([typeId]) | ||
| @@index([trackId]) | ||
| @@index([groups],type:Gin,map:"challenge_groups_gin_idx") |
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others.Learn more.
[correctness]
The use of a GIN index on thegroups array field is appropriate for efficient querying of array contents. Ensure that thepg_trgm extension is enabled in your PostgreSQL database to support this index type, as it is required for GIN indexes on text arrays.
https://topcoder.atlassian.net/browse/PM-2206