-- application paused: ALTER TABLE in progress

The application server is paused while a schema change runs on the primary database. The change rewrites every row in two tables.

-- migration 0042
BEGIN;
ALTER TABLE orders
  ADD COLUMN tax_rate numeric(6,4) NOT NULL DEFAULT 0,
  ADD COLUMN currency char(3) NOT NULL DEFAULT 'EUR',
  ALTER COLUMN total_cents TYPE bigint;
COMMIT;

-- migration 0043
CREATE INDEX CONCURRENTLY idx_orders_currency
  ON orders (currency, placed_at);
-- estimated time: 22 minutes on 22.4M rows

migration 1 of 2 · 54% · ~ 9 min remaining