The Bloat Busters: pg_repack vs. pg_squeeze

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

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

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

  • by glenjamin on 4/29/2024, 12:27:16 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/2024, 8:01:44 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?