So why are you using an RDBMS?
Because even a shitty RDMBS is more robust, more secure and faster than any NoSQL wankery for this kind of use case.
Postgres is robust, feature-filled, and scalable. You dont have to want all three to extract value from it.
There are even cases where performance has been found to be better than e.g: mongo: source: http://obartunov.livejournal.com/175235.html
There is a lot of momentum behind the improvements/additions. We will be seeing much more NoSql in 9.4, 9.5, and beyond.