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 53E50569.2080500@sigaev.ru
Whole thread Raw
In response to Re: jsonb format is pessimal for toast compression  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: jsonb format is pessimal for toast compression
List pgsql-hackers
> 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!)

May be I wasn't clear:jsonb type will start from string collection 
instead of JEntry array, JEntry array will be placed at the end of 
object/array. so, pg_lzcompress will find repeatable 4-byte pieces in 
first 1024 bytes of jsonb.

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



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Hokey wrong versions of libpq in apt.postgresql.org
Next
From: Bruce Momjian
Date:
Subject: Re: jsonb format is pessimal for toast compression