repair_segment table grows and grows -- what are your clean up mechanisms that you have in place ?

spotify / cassandra-reaper

Software to run automated repairs of cassandra

235 stars 60 forks source link

repair_segment table grows and grows -- what are your clean up mechanisms that you have in place ? #110

Closed djsly closed 6 years ago

djsly commented 9 years ago

reaper_db=> select count(*) from repair_segment;
count
--------
142081
(1 row)

I was wondering what you guys use to prevent the postgres DB from growing indefinitely.

From what I can see, the segments for runs that completed successfully don't really need to stay in the DB ?

Thanks!

varjoranta commented 9 years ago

There is no automated clean up mechanism currently, but when deleting the runs using the REST DELETE endpoints, the segments will get deleted as well.

djsly commented 9 years ago

I have added a PR https://github.com/spotify/cassandra-reaper/pull/119 for this automated feature.