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.
There is a GIN index on the
Document.text_vectorfield. However, exact word/phrase matches are done using regular expression pattern matching on theDocument.textfield. 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.