Agree. In my case, I went from Excel stare'n'compare to MS Access and finally mySQL for several years.

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.