From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Christopher Browne <cbbrowne(at)gmail(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Charles Pritchard <chuck(at)jumis(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: JSON Patch for PostgreSQL - BSON Support? |
Date: | 2010-08-16 15:48:57 |
Message-ID: | 1281973737.5303.5.camel@jd-desktop.unknown.charter.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 2010-08-16 at 11:40 -0400, Christopher Browne wrote:
> On Mon, Aug 16, 2010 at 11:21 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> > On Mon, Aug 16, 2010 at 11:05 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >> Andrew Dunstan <andrew(at)dunslane(dot)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.
>
> Yep, that was exactly what struck me. TOAST is quite likely to be a
> good answer for this.
Except: How much JSON data will actually be TOASTed?
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-08-16 15:49:51 | Re: "Bogus data in lock file" shouldn't be FATAL? |
Previous Message | Christopher Browne | 2010-08-16 15:40:28 | Re: JSON Patch for PostgreSQL - BSON Support? |