Skip to content

Default backfill merge batch size is too large for vector indexes #155283

@mw5h

Description

@mw5h

The default merge batch size, 1000, is much too large for efficient merging of vector indexes. At this large a batch size, merge workers encounter a lot of contention with fixups, which tanks performance. For a small merge set, like exist in unit tests, this isn't especially noticeable but, for larger merge sets, it can become indistinguishable from deadlock.

Jira issue: CRDB-55342

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.branch-release-25.4Used to mark GA and release blockers and technical advisories for 25.4target-release-26.1.0

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions