MP014CRITICALPro

large-table-ddl

What It Detects

Long-held locks on tables with 1M+ rows (from pg_class).

Why It's Dangerous

Operations that rewrite or scan large tables take proportionally longer, extending the lock duration. Production context from pg_class reveals actual table sizes.

Bad Example

-- DDL on a table with 50M rows

Good Example

-- Use CONCURRENTLY variants or partition strategy

Configuration

Disable this rule:

# .migrationpilotrc.yml
rules:
  MP014: false

Or change its severity:

# .migrationpilotrc.yml
rules:
  MP014:
    severity: warning