no-vacuum-full

What It Detects

VACUUM FULL rewrites the entire table under ACCESS EXCLUSIVE lock, blocking all reads and writes.

Why It's Dangerous

VACUUM FULL physically rewrites the entire table to reclaim disk space while holding an ACCESS EXCLUSIVE lock. Use pg_repack or VACUUM (without FULL) instead for online space reclamation.

Bad Example

VACUUM FULL users;

Good Example

-- Use regular VACUUM (no lock) or pg_repack
VACUUM users;

Configuration

Disable this rule:

# .migrationpilotrc.yml
rules:
  MP006: false

Or change its severity:

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