Sort of like a column store? ;) This is also rather how Reddit uses it I believe.

the json support is fairly recent and doesn't support operating directly on the data yet (e.g. you have to create functional indexes through plv8js and you can't directly query on the document's content as you can with array, xml or hstore columns)

I'm using https://github.com/JerrySievert/mongolike to support Postgres using mongo-like queries.

I patched in a bunch of features I needed, and it works really well for me.

PostgreSQL 9.3 adds functions for accessing JSON data without having to use plv8js.

Yeah but since it's just being added, it precludes "NoSQL guys" having built upon it, which is the original complaint.

Another intepretation of zapov's comment is that it's a shame the NoSQL projects didn't try achieving their goals by building postgres extensions (or even adding new features).

A reasonable question. MongoDB could have focused their energies on really good JSON support in postgres and making postgres sharding easier.

An interesting interpretation, which I had not considered. Thank you.

If there would be HandlerSocket or similar, yes.

Postgresql has prepared queries - they give you the same type of optimization (skip the query parsing on each execution) with more flexibility and with SQL standard syntax.

Prepared statements are far away from speedup you may get with handlersocket, even with https://github.com/dimitri/preprepare

You'd be better of with hstore than json.