Analyzing Schema Change Storage Risk

Estimates storage requirements for CockroachDB online schema change backfills using SHOW RANGES WITH DETAILS, KEYS, INDEXES. Use before CREATE INDEX, ADD COLUMN with INDEX/UNIQUE, ALTER PRIMARY KEY, CREATE MATERIALIZED VIEW, CREATE TABLE AS, REFRESH, or SET LOCALITY on tables with large per-index footprints, to avoid mid-backfill disk exhaustion.

cockroachdb Updated 0 repo stars

File contents

cockroachdb/copilot-plugin commit 2a422ba319

Frequently asked questions

npx get-skill add cockroachdb/analyzing-schema-change-storage-risk