FORGE // DATABASESClusters   Queries   Migrations

ledger-prod / migrations /

2026-10 settlement partition

PRODUCTION

Migration plan

CREATE TABLE settlement_route (...);
ALTER TABLE ledger_entry ADD route_id UUID;
CREATE INDEX CONCURRENTLY idx_ledger_route;
UPDATE ledger_entry SET route_id = resolve_route(...);
Rows affected2.84 billion
Estimated write lock38 seconds
Estimated runtime47 minutes