A key datapoint not mentioned in the article is "Can this be used on AWS RDS?" - to which I believe the only option that meets that criteria right now is `pg_repack`
> You migrate one or more column data types over a longer period (and no, using ALTER COLUMN name TYPE new_type is not the best option).
What is the best option then? Renaming the existing column to something else, creating a new column with `name` and then dropping the renamed column?
Pssst https://github.com/dataegret/pgcompacttable