I saw this presentation at Waza on Thursday. Being a relative newbie to Postgres, I was blown away by some of the tricks Peter showed off. Makes me wish I was using Postgres day to day.
As a day to day user, PostgreSQL is one of those tools that Just Works™
Another less known item is Trigram Indexing, which makes LIKE queries almost instant, especially when combined with tsvector indexes.