With indexes, so can MySQL or MariaDB. That’s why I said “unoptimized”. Postgres is certainly superior when it comes to more complex or analytical queries, but that’s because MySQL/MariaDB simply weren’t MADE for these kind of situations. And even postgres will struggle with an unoptimized, data-intensive workload. I’ve seen those in the wild.

It’s like shipping a formula 1 car into the desert and wondering why you’re last in the desert rally.