Re: JSON Patch for PostgreSQL - BSON Support? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: JSON Patch for PostgreSQL - BSON Support?
Date
Msg-id AANLkTi=n+ZsnVcVwZSTVOPkEebwLZVHvGbvaM9z9pb2P@mail.gmail.com
Whole thread Raw
In response to Re: JSON Patch for PostgreSQL - BSON Support?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: JSON Patch for PostgreSQL - BSON Support?
List pgsql-hackers
On Mon, Aug 16, 2010 at 11:05 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> If BSON is simply in effect an efficient encoding of JSON, then it's not
>> clear to me that we would want another type at all. Rather, we might
>> want to consider storing the data in this supposedly more efficient
>> format, and maybe also some conversion routines.
>
> Hmm, that's an interesting plan ...

It is interesting, but I'm not sure that it will actually work out
well in practice.  If what we want to do is compress JSON, TOAST will
do that for us without any additional code, and probably a lot more
efficiently.  Of course, until someone tests it, we're just
speculating wildly.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: "Bogus data in lock file" shouldn't be FATAL?
Next
From: Itagaki Takahiro
Date:
Subject: Re: Committers info for the git migration - URGENT!