|
|
|
|
|
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...). |
|