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.4

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions