cockroachdb / cockroachdb/cockroach

Slow Batched Insert and Index Spread Across Nodes Issue

Open
#107,542 0 comments 0 reactions 0 assignees View on GitHub
C-bug
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

**Describe the problem**

1. A batched insert on a table with two indexes is running pretty slow taking nearly 300ms to complete. The cluster is 5 nodes in a single-region. I've attached diag bundle.
2. In the initial load test, right after creating the indexes (on INT8 fields), we noticed the index was all in one place on one range on a single node. However, now we see that they have spread out across multiple ranges and multiple nodes. Is it normal for indexes to split like this after some time?

**Environment:**
- Dedicated
- Cockroach V22.2.11

Jira issue: CRDB-30102

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.