cmu-db / optd

CMU-DB's Cascades optimizer framework
https://cmu-db.github.io/optd/
MIT License
349 stars 19 forks source link

optimize: speed up stat gen by factor x15 #167

Closed AlSchlo closed 5 months ago

AlSchlo commented 5 months ago

Made the stat generation faster using Rayon's thread pool.

Various improvements, such as;

This takes 30s for JOB 1D stats on my computer, vs 7:30min before. Postgres takes 1:30min loading, and 22s for the stat gen. So we beat it, depending on how we view it.

On "real" datacenter hardware (i.e. 512 cores), we would crush it, we'll test that soon.

Finally coming together :-)