tables-movement-to-tablespace (US024)

Automatic fix is not available.

What it does

Checks tables movement to a different tablespace.

Why not?

Moving tables to a different tablespace acquires an ACCESS EXCLUSIVE lock on the respective tables, blocking other accesses until the movement is completed. This will cause downtime if the tables are concurrently being accessed by other clients.

When should you?

If the tables are empty. If the tables are not empty but is not being concurrently accessed.

Use instead:

Have a look at pg_repack as an alternative.