On Thu, 2024-05-09 at 09:58 -0400, Ron Johnson wrote: > Because vacuum is vacuum.
The problem is that the two commands do something different, so it would be misleading. Renaming VACUUM (FULL) is a good idea in principle, but I think that is more than 10 years too late. The compatibility break would be too painful.
Make VACUUM (FULL) a synonym for RECREATE TABLE, then say in the docs that VACUUM (FULL) is deprecated.
I think if you rename vacuum full then vacuum compact would be better fit than recreate table.