Do you need to create some new indexes? This sounds more like a problem with your database design and queries, than a problem inherent to mysql. PostgreSQL do

Do you need to create some new indexes? This sounds more like a problem with your database design and queries, than a problem inherent to mysql. PostgreSQL does provide some tools (EXPLAIN for instance) that can give you visibility into problems with your data design.