"Any database workload is performant while all the data fits in ram" No. Try querying 100 million+ records without good indexes even when it fits in ram. Any k

"Any database workload is performant while all the data fits in ram" No. Try querying 100 million+ records without good indexes even when it fits in ram. Any kind of query volume will get expensive fast.