tree ac61dc404f6aea51a19e2a4f83cd01ab2ff5599e
parent 6f08b6761221afd2437d2ce0a578983f41a661d8
author Julie Qiu <julie@golang.org> 1609460669 -0500
committer Julie Qiu <julie@golang.org> 1609867636 +0000

internal/postgres: insert v1path and series path to paths table

Paths that correlated to a v1path and series path are now also inserted
into the paths table. This will allow us to change units.v1_path to an
integer column with a FK to paths.id and reduce the size of the
idx_units_v1_path index (currently 19 GB in prod).

Additionally, in a future CL, this data can be used to redirect users
when request to pkg.go.dev/<path> 404s. For example:

/github.com/jackc/pgx/pgxpool -> /github.com/jackc/pgx/v4/pgxpool
/github.com/mediocregopher/radix ->
  /github.com/mediocregopher/radix/v3 or
  /github.com/mediocregopher/radix/v4

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