On Nov 20, 2010, at 9:31 PM, Terry Laurenzo wrote: > Assuming that the JSON datatype (at a minimum) normalizes text for storage, > then the text storage option accounts for about the most expensive path but > with none of the benefits of an internal binary form (smaller size, ability > to cheaply perform non-trivial manipulation within the database server). > > Of course, just having a JSON datatype that blindly stores text will beat > everything, but I'm getting closer to thinking that the binary option is > worth the tradeoff. > > Comments?
benchmarks++ Nice to have some data points for this discussion. Best, David, still hoping for the JSON data type in 9.1… -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
