4 ms·
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 stru
by h1fra 4y ago
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.
- fovc 4y agohttps://reorg.github.io/pg_repack/ https://reorg.github.io/pg_repack/ Dead easy to run and no long-held locks
- jaggederest 4y agoAbsolutely critical once you get above a certain table size.