If you end up needing full vacuuming to reduce bloat, there's also the pg_repack extension (it's even supported on RDS). The extension essentially creates a ne

If you end up needing full vacuuming to reduce bloat, there's also the pg_repack extension (it's even supported on RDS). The extension essentially creates a new table without the block and replaces the original one, keeping track of changes to the table using trigger; so the exclusive lock of VACUUM FULL is not needed for quite the long time.