8000 Add `pg_trgm` index for document `title` · Issue #8448 · outline/outline · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Add pg_trgm index for document title #8448

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.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
tommoor opened this issue Feb 16, 2025 · 1 comment · Fixed by #8454
Closed

Add pg_trgm index for document title #8448

tommoor opened this issue Feb 16, 2025 · 1 comment · Fixed by #8454
Assignees
@tommoor
Labels
performance

Comments

@tommoor
Copy link
Member
tommoor commented Feb 16, 2025

suggestions.mention is far too slow, we need to index document titles – however we are using an ilike search for fuzzy matching, it would be best to add a trigram index here.
@linear Linear
Copy link
linear bot commented Feb 16, 2025

OLN-896 Add `pg_trgm` index for document `title`

@tommoor tommoor self-assigned this Feb 17, 2025
@tommoor tommoor mentioned this issue Feb 17, 2025
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@tommoor tommoor

Labels
performance
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

perf: Add trigram index for doc title search outline/outline
1 participant
@tommoor
0