4 ms·
PostgreSQL's solution makes sequential scans and secondary indexes faster, while MySQL's makes primary key lookups faster. I believe there also are trade offs w
by jeltz 15y ago
PostgreSQL's solution makes sequential scans and secondary indexes faster, while MySQL's makes primary key lookups faster. I believe there also are trade offs when it comes to updates and the cost of updating indexes.
- rhaas 15y agoYep, see http://rhaas.blogspot.com/2010/11/mysql-vs-postgresql-part-1-table.html http://rhaas.blogspot.com/2010/11/mysql-vs-postgresql-part-1...