tree 1ea198a7f726d4cdff107a304afa311bdb55d505
parent 037582b9f5929b49db77f9b35b599a4ea5d847ac
author Julie Qiu <julie@golang.org> 1629394132 -0400
committer Julie Qiu <julie@golang.org> 1629409656 +0000

migrations: add idx_symbol_search_documents_symbol_name_imported_by_count

Adding INDEX idx_symbol_search_documents_symbol_name_imported_by_count
significantly improves performance when searching for popular symbols,
such as "new" or multi-word searches that contain two possible symbol
names, such as "new error".

For golang/go#44142

Change-Id: Id41a06af6fde53f601b3c4efbcdcf78fc9f02a4d
Reviewed-on: https://go-review.googlesource.com/c/pkgsite/+/343652
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>