Curious about your project - you have some claims that your engine is multiple times faster than Postgres. You also mention that you are “using all the cores” in your system.

Is it correct to assume that the core innovation here that you are parallelizing your queries? If so, have you tried benchmarking with parallel queries enabled in Postgres (eg., one test would be to increase the number of workers allowed per query)

https://www.postgresql.org/docs/current/how-parallel-query-w...