I appreciate you carrying the torch for MySQL here, since most opinions are based on setups over a decade old, with little to no bearing on how it runs today
Depends on the underlying database, and you'd have to test your query to have any level of certainty.
That being said, query planning is generally where Oracle/MSSQl outshine MySQL/Postgres, especially for pruning unnecessary joins. BigQuery is great at it IME.
I'm not sure either of those examples is true. For servers, Linux won, but that's just a fraction of OS usage. MySQL still has much higher usage rates than Postgres, particularly at massive scale, so calling that "won" is premature at best
They didn't have particularly great reasons to migrate at the time besides the team wanting to write rust. That article is just trying to provide validation
Lago continues to pretend to be OSS, when it's unusable as is. I had so much hope for it, and while I don't begrudge them monetizing, it's a sham. You can't even make a refund with the OSS license.
I very much appreciate your deep knowledge of MySQL, and willingness to share amidst the sea of postgres fans. There's a reason both are popular and widely used.