Re: jsonb format is pessimal for toast compression

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: jsonb format is pessimal for toast compression
Дата
Msg-id 53E50569.2080500@sigaev.ru
обсуждение исходный текст
Ответ на Re: jsonb format is pessimal for toast compression  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: jsonb format is pessimal for toast compression  (Alexander Korotkov <aekorotkov@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Hokey wrong versions of libpq in apt.postgresql.org
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: jsonb format is pessimal for toast compression