cockroachdb / cockroachdb/cockroach

backupccl: SHOW BACKUP reports inaccurate size_bytes and file_bytes for small tables in coalesced ranges

Open
#95,174 1 comment 0 reactions 0 assignees View on GitHub
A-disaster-recovery C-bug stability-period T-disaster-recovery
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

SHOW BACKUP currently reports an estimate for the size of each backed up table in logical and physical bytes. This estimate assumes that each table lives in its own range. As of 22.2 and earlier, this assumption would occasionally lead to inaccurate estimates, such as if the backup was taken just after a table had been created, but before the table was split into its own range, and we lived with this transient inaccuracy. In 23.1 however, coalesced ranges will be default on, which means that SHOW BACKUP size estimates for small tables (i.e. those coalesced into a range), will be consistently inaccurate. We should address this.

Jira issue: CRDB-23384

Epic CRDB-21944

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.