tree 8265bb05db8f0f28c6696728c4db24f0caa79cd3
parent 15daa8c2ded7e77f6d29f078ff446fae81e23edd
author Julie Qiu <julie@golang.org> 1607467431 -0500
committer Julie Qiu <julie@golang.org> 1608063452 +0000

internal/postgres: rewrite GetUnitMeta query

The query for GetUnitMeta is refactored behind an experiment flag, in
order to fix QueryRowContext timeout issues from the existing query.

Initial experiments on dev show the following improvements for the
first invocation:

cloud.google.com/go: 881ms -> 22ms
golang.org/x/tools: 3423ms -> 160ms

The second call took <40ms on both queries.

Change-Id: I7f356e29ee3354545a866c75e304b0d69cd43364
Reviewed-on: https://go-review.googlesource.com/c/pkgsite/+/276297
Trust: Julie Qiu <julie@golang.org>
Run-TryBot: Julie Qiu <julie@golang.org>
Reviewed-by: Jonathan Amsterdam <jba@google.com>