commit | ad7af847563b47baff66c1866da0294ade04ac6e | [log] [tgz] |
---|---|---|
author | Julie Qiu <julie@golang.org> | Wed Aug 18 12:14:11 2021 -0400 |
committer | Julie Qiu <julie@golang.org> | Wed Aug 18 20:44:32 2021 +0000 |
tree | ac3b46389d69ef3ce8a72840ec33ec1a75a5c436 | |
parent | 2f68266c43812ed47dc096377c4a331355ae848e [diff] |
migrations: add idx_search_documents_tsv_path_tokens A GIN index is added on search_documents.tsv_path_tokens to improve performance for multi-word searches. This should reduce the query below from 1.6s to 250ms. ``` SELECT * FROM search_documents WHERE tsv_path_tokens @@ to_tsquery('symbols', 'blake2b'); ``` For golang/go#44142 Change-Id: I130df35b36ba9420e12610323334c329f69f211e Reviewed-on: https://go-review.googlesource.com/c/pkgsite/+/343290 Trust: Julie Qiu <julie@golang.org> Run-TryBot: Julie Qiu <julie@golang.org> TryBot-Result: kokoro <noreply+kokoro@google.com> Reviewed-by: Jonathan Amsterdam <jba@google.com>
Pkg.go.dev is a website for discovering and evaluating Go packages and modules.
You can check it out at https://pkg.go.dev.
If you want to report a bug or have a feature suggestion, please first check the known issues to see if your issue is already being discussed. If an issue does not already exist, feel free to file an issue.
For answers to frequently asked questions, see go.dev/about.
You can also chat with us on the #pkgsite Slack channel on the Gophers Slack.
We would love your help!
Our canonical Git repository is located at go.googlesource.com/pkgsite. There is a mirror of the repository at github.com/golang/pkgsite.
To contribute, please read our contributing guide.
Unless otherwise noted, the Go source files are distributed under the BSD-style license found in the LICENSE file.