tree 7b90c81dd6e6685b8f09bdf5320ed71b8ef8e2ea
parent 014d38720fa5112d767210cb7a8e184d1b3695bb
author Jonathan Amsterdam <jba@google.com> 1652705524 -0400
committer Jonathan Amsterdam <jba@google.com> 1652706918 +0000

internal/postgres: update imported-by counts in smaller batches

The worker periodically updates search_documents.imported_by_count
from the imports_unique table. It does so in batches to avoid locking
search_documents for too long.

Currently the batch size causes the update query to time out, so
reduce it.

Change-Id: If86d272f0677dbedab104e2e1e235d7f2e1e4b25
Reviewed-on: https://go-review.googlesource.com/c/pkgsite/+/406296
Reviewed-by: Jamal Carvalho <jamal@golang.org>
Run-TryBot: Jonathan Amsterdam <jba@google.com>