3 ms·
From my perspective MySQL does secondary index is much better than PostgreSQL. Uber found that out the hard way.
by pbhowmic 10y ago
From my perspective MySQL does secondary index is much better than PostgreSQL. Uber found that out the hard way.
- lngnmn 10y agoPostgreSQL has implementation of almost every possible indexing technique, unlike MySQL. It has been academic project (of great scholars) after all.
- SigmundA 10y agoExcept clustered indexes.
- Tostino 10y agoThere are tradeoffs with both design, I know that I use secondary indexes in quite a lot of my queries, so the way Postgres handles them are much better in my case... but in someone else's use case (Uber) it could be terrible for performance.