tree 947927c46be18b1333820d1f9b8e1fbe153f0f5e
parent 1c31e680809b8371bcf5f494b60c8fd5526a4769
author Julie Qiu <julie@golang.org> 1629393007 -0400
committer Julie Qiu <julie@golang.org> 1629409667 +0000

internal/postgres/symbolsearch: update queries

The symbol search queries are updated to ORDER BY imported_by_count and
use the new idx_symbol_search_documents_symbol_name_imported_by_count
index.

symbol_name_id is removed as a sort clause, since it isn't possible for
a single package to have more than 1 result per symbol, now that we
don't allow searching by just field or method names.

For golang/go#44142

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