zlacker

Once you figured out all the point in this article, it's a matter of fine tuning, can take some times but eventually it will works. The only thing I still struggle with is the Table Bloat.

On managed Postgres (i.e: gcp, aws) you pay for the disk, but when you can't run a VACUUM FULL because it locks the table, you end up with a lot of allocated storage for nothing and you can't shrink the disk size (at least on gcp). Storage is cheap but still feels like a waste.

>>h1fra+(OP)
https://reorg.github.io/pg_repack/

Dead easy to run and no long-held locks

>>fovc+R4
Absolutely critical once you get above a certain table size.