tree ac3b46389d69ef3ce8a72840ec33ec1a75a5c436
parent 2f68266c43812ed47dc096377c4a331355ae848e
author Julie Qiu <julie@golang.org> 1629303251 -0400
committer Julie Qiu <julie@golang.org> 1629319472 +0000

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>