Postgres Pro
Downloads
Home   >   mailing lists

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

From Teodor Sigaev
Subject Re: jsonb format is pessimal for toast compression
Date
Msg-id 53E50449.4010608@sigaev.ru
Whole thread Raw
In response to jsonb format is pessimal for toast compression  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: jsonb format is pessimal for toast compression
List pgsql-hackers
Tree view 
> value-to-be-compressed.  (first_success_by is 1024 in the default set of
> compression parameters.)

Curious idea: we could swap JEntry array and values: values in the 
begining of type will be catched by pg_lzcompress. But we will need to 
know offset of JEntry array, so header will grow up till 8 bytes 
(actually, it will be a varlena header!)


-- 
Teodor Sigaev                      E-mail: teodor@sigaev.ru                                      WWW:
http://www.sigaev.ru/

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: replication commands and log_statements
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Hokey wrong versions of libpq in apt.postgresql.org