https://cedardb.com/docs/technology talks about the technical details on how they maximize their usage of available cores and RAM, and their query optimizer.