Re: jsonb and nested hstore - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: jsonb and nested hstore
Date
Msg-id 52F27EAA.3000509@dunslane.net
Whole thread Raw
In response to Re: jsonb and nested hstore  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: jsonb and nested hstore  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On 02/05/2014 12:48 PM, Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> On 02/05/2014 11:40 AM, Tom Lane wrote:
>>> switching to "binary is the same as text" may well be the most prudent
>>> path here.
>> If we do that we're going to have to live with that forever, aren't we?
> Yeah, but the other side of that coin is that we'll have to live forever
> with whatever binary format we pick, too.  If it turns out to be badly
> designed, that could be much worse than eating some parsing costs during
> dump/restore.
>
> If we had infinite time/manpower, this wouldn't really be an issue.
> We don't, though, and so I suggest that this may be one of the better
> things to toss overboard.
>
>             


The main reason I'm prepared to consider this is the JSON parser seems 
to be fairly efficient (See Oleg's recent stats) and in fact we'd more 
or less be parsing the binary format on input anyway, so there's no 
proof that a binary format is going to be hugely faster (or possibly 
even that it will be faster at all).

If anyone else has opinions on this sing out pretty darn soon (like the 
next 24 hours or so, before I begin.)

cheers

andrew



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Prohibit row-security + inheritance in 9.4?
Next
From: Peter Geoghegan
Date:
Subject: Re: Misaligned BufferDescriptors causing major performance problems on AMD