Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Have you tried pg_repack? We had some great success with it on large tables with lots of bloat


It’ll probably shave 50% off that table’s disk space.

However, we’re actually in the process of sharding the db, and by copying customer by customer we’ll lose the bloat that way. The subsequent shards will be a lot more manageable so we can run pg_repack there with more confidence.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: