News for hackers. Stuff that matters.
Re:A proof of concept MongoDB clone built on Postgres by jerrysievert on Monday April 20, 2015 @11:37AM (#9408797)
currently, that is exactly how they are handled. the JSON structure is brought into memory, parsed, modified, and then written again to the database.

this is non-optimal, but currently the only method available.

Re:A proof of concept MongoDB clone built on Postgres by nunwuo on Monday April 20, 2015 @02:10PM (#9409824)
That wouldn't change even if there was a specialized syntax, because of MVCC. So the only problem is that syntactic sugar is lacking, not that the performance isn't as good as it could be.