A few hundred users and MySQL started to complain...
olefoo: 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.