Skip to content
This repository was archived by the owner on Sep 30, 2024. It is now read-only.

Consolidate indexes on repo table #57472

Open
@eseliger

Description

@eseliger

Writes to the repo tables are very slow. Updating 50,000 rows takes about 12 seconds locally, and my database only contains a bit more than that records.
I see that we have indexes that feel like they might be overlapping, and many different index types on the name column.

We should figure out which of these are actually required.

/cc @sourcegraph/source

Metadata

Metadata

Assignees

No one assigned

    Labels

    debtTechnical debt.perfteam/sourceTickets under the purview of Source - the one Source to graph it all

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions