I would definitely try postgres before MySQL. Had plenty of shitty query optimizations from MySQL. But besides that, how much mb are 100million? And what is

I would definitely try postgres before MySQL. Had plenty of shitty query optimizations from MySQL. But besides that, how much mb are 100million? And what is your goal?