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

From Heikki Linnakangas
Subject Re: JSON Patch for PostgreSQL - BSON Support?
Date
Msg-id 4C6974A5.5070500@enterprisedb.com
Whole thread Raw
In response to Re: JSON Patch for PostgreSQL - BSON Support?  (Joseph Adams <joeyadams3.14159@gmail.com>)
List pgsql-hackers
On 16/08/10 20:17, Joseph Adams wrote:
> Also, an idea would be to make json_send and json_recv (binary JSON
> send/receive) use BSON rather than JSON-encoded text, as
> sending/receiving JSON-encoded text is exactly what text send/receive
> do.

The usual reason to use the binary format is performance, so it doesn't 
make much sense to use BSON for that if the internal storage format is 
something else. It would most likely be slower, not faster, than sending 
the string as is.

Of course, if you switch to using BSON as the internal storage format, 
then it's natural to use that for the binary I/O format too.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: Proposal / proof of concept: Triggers on VIEWs
Next
From: Magnus Hagander
Date:
Subject: Todays git migration results