Open michielbdejong opened 7 years ago
Workaround:
psql <your-postgres-url>
DELETE FROM "L_TRANSFER_ADJUSTMENTS" WHERE "DB_CREATED_DTTM" < DATE('2017-02-21');
DELETE FROM "L_FULFILLMENTS" WHERE "DB_CREATED_DTTM" < DATE('2017-02-21');
DELETE FROM "L_ENTRIES" WHERE "DB_CREATED_DTTM" < DATE('2017-02-21');
DELETE FROM "L_TRANSFERS" WHERE "PROPOSED_DTTM" < DATE('2017-02-21');
VACUUM FULL;
\q
This worked for me to bring the database down from 7,000 to 2,000 records, and it seems my ilp-kit is still working. :)
On Heroku Free Tier, only 10,000 database records are allowed, so it would be nice-to-have if the admin could click a button in the UI to truncate the history