One of my friends/server buddy recently switched his Drupal web site to PostgreSQL from MySQL and you can definitely tell the difference.
Again PostgreSQL is faster (with my limited concurrency anyways). With the timed benchmark I also noticed that the longest time taken for a page with MySQL was 8266ms, compared to PostgreSQL’s 564ms.