The phlogiston database is taking up to 60Gb on labs servers, causing disk usage failures.

• Remove unused indexes
  • Identify unused indexes
    • build clean new server (or reset dev)
    • run for a few days
    • query for unused indexes (https://wiki.postgresql.org/wiki/Index_Maintenance)
  • remove unused indexes from creation scripts
  • remove unused indexes from production database
• shrink existing indexes

As of March 20, 2019, some of this has been done manually to reduce pressure on servers.