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

From Bruce Momjian
Subject Re: jsonb format is pessimal for toast compression
Date
Msg-id 20140814165248.GB7865@momjian.us
Whole thread Raw
In response to Re: jsonb format is pessimal for toast compression  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: jsonb format is pessimal for toast compression
Re: jsonb format is pessimal for toast compression
List pgsql-hackers
On Thu, Aug 14, 2014 at 12:22:46PM -0400, Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Uh, can we get compression for actual documents, rather than duplicate
> > strings?
> 
> [ shrug... ]  What's your proposed set of "actual documents"?
> I don't think we have any corpus of JSON docs that are all large
> enough to need compression.
> 
> This gets back to the problem of what test case are we going to consider
> while debating what solution to adopt.

Uh, we just one need one 12k JSON document from somewhere.  Clearly this
is something we can easily get.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +



pgsql-hackers by date:

Previous
From: "Tomas Vondra"
Date:
Subject: Re: 9.5: Memory-bounded HashAgg
Next
From: Robert Haas
Date:
Subject: Re: 9.5: Better memory accounting, towards memory-bounded HashAgg