Can you elaborate on how does thread per core work in context of the database and how/why it is beneficial
The key insight being that in this model "locks are never necessary", which is huge source of efficiency when working with sharded data across multiple cores.
> Thread-per-core architectures are friendly to modern hardware, as their local nature helps the application to take advantage of the fact that processors ship with more and more cores while storage gets faster, with modern NVMe devices having response times in the ballpark of an operating system context switch.