nickva commented on PR #5603: URL: https://github.com/apache/couchdb/pull/5603#issuecomment-3255886441
> If you still want to retain 60 buckets, how about: > > - 1 bucket a day for 30 days > - 1 bucket a month for 24 months for changes older than 30 days > - 1 bucket a year for 5 years for changes older than 30 days + 24 months > - 1 bucket for everything older than that > > 30 days + 24 months + 5 years + 1 = 60 I started with something like that in the beginning but wanted something less than a 24 h day, I could see someone wanting to know what part of the changes happened, morning afternoon, etc so "hours" got about 4 buckets. Then I also had the sharper transitions like that from a day 30th day to month, but wanted something more gradual, so we may skip 1 or two days in between, as opposed going from 1 day straight to a month. It's also worth point out that if there is not enough time to fill up decades and such, the rest of the 60 bins will still be utilized with more recent intervals. For instance the first 60 * 3h updates, all 60 bins would be filled with 3h intervals. Then to make room we'd merge some into 6h, so it will become a mix of 3h and 6h intervals after (with 6h ones towards the end). We can try a few more example of schedules and see which ones we like better. I'll generate some in a bit -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
