from Hacker News

The Bloat Busters: pg_repack vs. pg_squeeze

by radimm on 4/28/24, 6:17 AM with 12 comments

• by Valodim on 4/29/24, 8:30 AM

  Pssst https://github.com/dataegret/pgcompacttable

• by glenjamin on 4/29/24, 12:27 PM

  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`

• by ksynwa on 4/29/24, 8:01 AM

  > 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?