# Specify custom purge interval for «scheduler\_stats» tables

**URL:** https://meta.discourse.org/t/specify-custom-purge-interval-for-scheduler-stats-tables/61785
**Category:** Feature
**Created:** [Abril 28, 2017, 5:04pm UTC](https://meta.discourse.org/t/specify-custom-purge-interval-for-scheduler-stats-tables/61785 "2017-04-28T17:04:47Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![dmitry\_fedyuk](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/dmitry_fedyuk/32/293153_2.png) [@dmitry\_fedyuk](https://meta.discourse.org/u/dmitry_fedyuk)
#### Post date: [Abril 28, 2017, 5:04pm UTC](https://meta.discourse.org/t/specify-custom-purge-interval-for-scheduler-stats-tables/61785/1 "2017-04-28T17:04:48Z")

</div>

These 2 useless for me tables take 99.9% of my database’s disk space:

> <https://github.com/discourse/discourse/blob/v1.8.0.beta11/app/models/scheduler_stat.rb#L2-L4>

 ![](https://global.discourse-cdn.com/meta/original/3X/c/a/ca4e734dc7b4480c0829b011a749953e48717e8b.png)

---

<div class="post-metadata">

### Author: ![eviltrout](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/eviltrout/32/5275_2.png) [@eviltrout](https://meta.discourse.org/u/eviltrout)
#### Post date: [Abril 28, 2017, 6:40pm UTC](https://meta.discourse.org/t/specify-custom-purge-interval-for-scheduler-stats-tables/61785/2 "2017-04-28T18:40:36Z")

</div>

Personally I don’t see this as a big problem. 39MB is pretty small as far as installed software goes. As your forum grows in data, you’ll see a much smaller percentage of usage.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [Abril 28, 2017, 9:32pm UTC](https://meta.discourse.org/t/specify-custom-purge-interval-for-scheduler-stats-tables/61785/3 "2017-04-28T21:32:36Z")

</div>

So your complaint is that these are “only” purged every 3 months?

Looking at this `scheduler_stats` table and the data in it, seems ultra pointless to me, nobody can even tell me why it’s there .. cc @sam

I am gonna change it to purge anything **older than 1 month** so that will cut its size by 2/3rds while certainly retaining enough data rows for.. whatever the hell this is for in the first place..

This should help DB storage space a bit on our hosting as well as we have tons and tons of vacant hosted sites (for trials, etc).
