3 ms·
> Postgres also had a reputation for being correct but slower Even back then, I found that mysql was faster for “select * from table where primary_key = 42”, b
by Shish2k 3y ago
> Postgres also had a reputation for being correct but slower
Even back then, I found that mysql was faster for “select * from table where primary_key = 42”, but with even the slightest complication (joins, functional queries, subqueries), postgres pulled ahead.
I guess a huge percentage of SQL queries are really just key-value lookups though, so I can’t blame people for using mysql too much (this was before memcached, let alone redis et al)