Hacker News new | ask | show | jobs
by lazyjones 3747 days ago
Several things:

- disks (SSDs) are very fast now, so cores are saturated more easily (when queries actually process the data instead of just reading it)

- multiple parallel (random) reads will likely be faster on HDD and SDD to some extent (esp. on larger RAID setups)

- the best optimization is still lots of RAM and people have that these days, so 100% CPU utilization during queries happens more often than not (the benchmarking setup seems suitable for more than 1 billion rows...).