tree 8210c9ba2e4a752302685ed616b517eb08280971
parent dc9827cf06454afff4b024ac63e982f33fef1c76
author Julie Qiu <julie@golang.org> 1614039046 -0500
committer Julie Qiu <julie@golang.org> 1614115172 +0000

internal/postgres: change upserts for symbol_names and package_symbols

To avoid unnecessary write attempts when inserting symbols information,
run a SELECT query first to get existing symbol names and package
symbols, and only insert rows that we know do not exist.

For golang/go#37102

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