In a postgres database, a VACUUM FULL on a table will reclaim any free space by completely re-writing the table.
Also, moving a table from one tablespace to another (using ALTER TABLE... SET TABLESPACE) will re-write the table (assuming the other tablespace is on another disc).
So, is there anything to be gained by doing both VACUUM FULL and SET TABLESPACE on the same table? or in other words, will the VACUUM FULL recover any space that altering the tablespace wouldn't do anyway?
This is related to this post, but it's nearly ten years old and refers to an obsolete version of postgres.
