Postgres

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

• Remove unused index
• Clear bloat in index (i.e. updated rows that are stored as: original marked as deleted and new row inserted)
• pg_repack to repack index
• using partial index if you have index on a column whose some of the value you never query e.g. if a column is nullable and there are alot of nulls but you don't query with `WHERE colmn IS NULL` then create a partial index for non null values only for that column

pg_dump super_app > backup.dump pg_restore super_app < backup.dump

pg_dump -U user_name -Fc database_name > dump_filename

References

• https://hakibenita.com/postgresql-unused-index-size (Postgres)