They Freed up 70GB of Unused Indexes Space on Postgres, How did they Do it?

The Backend Engineering Show with Hussein Nasser

English - February 02, 2021 19:46 - 18 minutes - 10.7 MB - ★★★★★ - 5 ratings
Technology Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed

Previous Episode: How do I learn new tech as a software engineer

Next Episode: UUIDs are Bad for Performance in MySQL - Does Postgres Win? Let us Discuss

This is a very interesting article that I encourage you to read it as it has lots of useful lessons in postgres. Using partial indexes, full vacuum, dropping unused indexes and much more helped this company save 70G worth of disk space.

https://hakibenita.com/postgresql-unused-index-size