Re: jsonb format is pessimal for toast compression - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: jsonb format is pessimal for toast compression
Date
Msg-id CAM3SWZRLm47+Ga6APecLMNu7devfLehyvQe-73ObUgec-Cjr5Q@mail.gmail.com
Whole thread Raw
In response to Re: jsonb format is pessimal for toast compression  (Josh Berkus <josh@agliodbs.com>)
Responses Re: jsonb format is pessimal for toast compression
Re: jsonb format is pessimal for toast compression
List pgsql-hackers
On Mon, Sep 15, 2014 at 4:05 PM, Josh Berkus <josh@agliodbs.com> wrote:
> Actually, having the keys all at the same level *is* relevant for the
> issue we're discussing.  If those 270 keys are organized in a tree, it's
> not the same as having them all on one level (and not as problematic).

I believe Robert meant that the 270 keys are not at the top level, but
are at some level (in other words, some object has 270 pairs). That is
equivalent to having them at the top level for the purposes of this
discussion.

FWIW, I am slightly concerned about weighing use cases around very
large JSON documents too heavily. Having enormous jsonb documents just
isn't going to work out that well, but neither will equivalent designs
in popular document database systems for similar reasons. For example,
the maximum BSON document size supported by MongoDB is 16 megabytes,
and that seems to be something that their users don't care too much
about. Having 270 pairs in an object isn't unreasonable, but it isn't
going to be all that common either.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Emanuel Calvo
Date:
Subject: Re: Turning off HOT/Cleanup sometimes
Next
From: Peter Geoghegan
Date:
Subject: Re: B-Tree support function number 3 (strxfrm() optimization)