Single threaded writer
As of the conferences last year at least, the biggest limitation to Postgres in terms of performance is that it has a single threaded writer. You can have multithreaded readers, just not writers. For databases that have a lot of writes, this is a huge bottleneck compared to databases like Oracle. However, for the majority of databases, this is not an issue.