PgSQL more and more looks like the "redis of databases". Whatever the problem, you can almost always find a good reason to use it :)

You get great performance for the simple "dumb" use case (relational data in DB term, key/value store in redis case), and lots of awesome additional feature on top of it for more complex situations.

I love it.