3 ms·
How do you decide what sets of users you pre aggregate? It seems like without some limits in place you could end up with huge number of sets, especially if you
by msaspence 11y ago
How do you decide what sets of users you pre aggregate?
It seems like without some limits in place you could end up with huge number of sets, especially if you are calculating these based on event properties.
- paladin314159 11y agoThat's a great observation. Somewhere along the spectrum of query flexibility you reach a point where pre-aggregation doesn't work anymore. We have a separate column-store based system in place for certain types of queries which we'll almost certainly blog about in the future!
- msaspence 11y agoHow does that then affect your cost efficiency. What clever things are you doing with this to keep your costs so low? I guess we'll find out in a future post.