i had a similar issue with mongo and time series data. for special purpose event data like that gist, i think you should consider using a column store.
Re:InfluxDB Clustering Beta and Data Explorer
by mattbillenstein on Thursday June 23, 2016 @06:18PM
(#11964710)
I may eventually -- we're using mongo for the rest of the metadata for now, so this is good enough to not need something else at the moment.
I compared a dataset to postgres and the new mongo storage engine is very good -- dunno if wiredTiger is something you guys are looking at, but it's very compact and fast to query with the proper indexes.
Dumped some stats into a gist as well: https://gist.github.com/mattbillenstein/89969980025414e2bca8...