On Mon, Feb 24, 2014 at 8:46 AM, Merlin Moncure <mmonc...@gmail.com> wrote: > I still find the phrasing "as jsonb is more efficient for most > purposes" to be a bit off Basically, the text json type is faster for > serialization/deserialization pattern (not just document preservation) > and jsonb is preferred when storing json and doing repeated >subdocument accesses.
Hm, I'm going to withdraw that. I had done some testing of simple deserialization (cast to text and the like) and noted that jsonb was as much as 5x slower. However, I just did some checking on json[b]_populate_recordset though and it's pretty much a wash. merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
