Skip to content
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

Speed text searches? #115

Open
jywsn opened this issue Dec 1, 2015 · 0 comments
Open

Speed text searches? #115

jywsn opened this issue Dec 1, 2015 · 0 comments
Milestone
Iteration 0.3

Comments

@jywsn
Copy link
Contributor

jywsn commented Dec 1, 2015

There is a GIN index on the Document.text_vector field. However, exact word/phrase matches are done using regular expression pattern matching on the Document.text field. I don't think there is a way to speed up such non-left anchored searches with an index, but this could use additional verification.
@jywsn jywsn added this to the PostgreSQL full text search milestone Dec 1, 2015
@hbillings hbillings modified the milestones: PostgreSQL full text search, Iteration 0.2, Iteration 1.0 Jan 13, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
Iteration 0.3
Development

No branches or pull requests
2 participants
@hbillings @jywsn