Comment on MySQL has quesadillas?
Overspark@piefed.social 1 week agoIf you ignore the “no indexes” part (can’t request that in normal SQL anyway) then PostgreSQL absolutely can handle queries like that.
Comment on MySQL has quesadillas?
Overspark@piefed.social 1 week agoIf you ignore the “no indexes” part (can’t request that in normal SQL anyway) then PostgreSQL absolutely can handle queries like that.
realitaetsverlust@piefed.zip 1 week ago
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.