Hacker News Reader

Perhaps this is a naive question, but why is PostgreSQL so incredibly dominant in these rankings?

Because Postgres has been profiled and tuned for performance for decades?

All hail Michael Stonebraker and Tom Lane. The Turing award and Wikipedia cannot be wrong.