vacuum-full (US026)

Automatic fix is not available.

What it does

Checks vacuum full.

Why not?

When a table is being vacuumed with the FULL option, an ACCESS EXCLUSIVE lock is acquired on it, preventing any other database operations (both reads and writes) from operating on the table until the VACUUM FULL is finished. This will cause downtime if the table is concurrently being accessed by other clients.

When should you?

If the table is empty. If the table is not empty but is not being concurrently accessed.

Use instead:

Have a look at pg_repack as an alternative.