mySQL worked great for my lil piece of company business involving a few million records. But then I volunteered to do some analysis with files an order or two of magnitude larger (10 mlllion-100 million). mySQL started coughing up with memory errors. Uh oh. Embarrassing.
I should mention that I'm doing all this on a Windows desktop, as that's what is installed and locked down on the machines they give me.
Enter postGRES. No matter what I throw at it, it gets to end of the queries without errors—in Windows, no less. With an nVME and 32 GB of ram, I can run a complex report on 70M records in seconds. Loading and indexing takes about 15 min.
mySQL was very very good to me for a long time, but for the really big stuff I'm sticking with PostGRES.