Skip to content
pgdeadbolt

table-rewrite-command

Don't VACUUM FULL or CLUSTER in a migration.

Severity: error · Lock: ACCESS EXCLUSIVE

Both copy the entire table into new storage while holding ACCESS EXCLUSIVE.

Instead of

Section titled “Instead of”
VACUUM FULL users;

Do

Section titled “Do”
-- Rebuild online with pg_repack or pg_squeeze, outside migrations.

To skip this rule for one statement, put -- pgdeadbolt-ignore table-rewrite-command on the line above it.