Something went wrong on our end. Please try again.
Created by: efritz
This PR updates the upsertRepositoryName
, upsertLanguageName
and upsertTags
methods used by API docs. The latter query is the currently dominating query for load by total time in codeintel-db, and is almost 100% lock wait.
I believe that ON CONFLICT
is quite expensive in this context and we are better to do a multi-stage tags update:
We also do something similar for repository and langauge name. If lock contention largely goes away after this, I thikn we can probably put the repo and language name upserts back into the same txn.
Helps #21938