[MrStonedOne]

>There are several ways to rebuild a table and reduce bloat:

>Re-create the table: Using this method as described above often requires a lot of development, especially if the table is actively being used as it's being rebuilt.

>Vacuum the table: PostgreSQL provides a way to reclaim space occupied by dead tuples in a table using the VACUUM FULL command. Vacuum full requires a lock on the table, and is not an ideal solution for tables that need to be available while being vacuumed:

This is confusing to me, i thought postgre was suppose to be better then mysql, yet mysql has a non-locking command to recreate a table. it has like 3 that would fit here, AND deal with the indexes in one command.