tree 4a6cbe6a19920ea1b54f7e29a6d6f3158afabdd2
parent 678db8901556d4ed5a8f05c278a988703c39b0be
author Julie Qiu <julie@golang.org> 1607552720 -0500
committer Julie Qiu <julie@golang.org> 1607610590 +0000

internal/postgres: fix GetLatestMajorVersion query

At the moment, the GetLatestMajorVersion query from CL 274413 takes a
long time to load (56s for golang.org/x/tools in prod) .

The existing query changed and split in two to improve performance.

golang.org/x/tools now takes ~100ms.

Additional data:
Current: https://photos.app.goo.gl/NEtjwmjryEdtxhnE9
Updated: https://photos.app.goo.gl/Lx1Zt2bbqUami8Y46

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