Re: ZSON, PostgreSQL extension for compressing JSONB

Поиск
Список
Период
Сортировка
От Alan Gano
Тема Re: ZSON, PostgreSQL extension for compressing JSONB
Дата
Msg-id CAOdxOuawUyPu-cVzq325ARXirn87CLTg2c7-oG=gcL87D6e89g@mail.gmail.com
обсуждение исходный текст
Ответ на ZSON, PostgreSQL extension for compressing JSONB  (Aleksander Alekseev <a.alekseev@postgrespro.ru>)
Список pgsql-general
I like this, seeing that the keys of JSON docs are replicated in every record.

I makes my old-school DBA-Sense start to itch.



On Fri, Sep 30, 2016 at 8:58 AM, Aleksander Alekseev <a.alekseev@postgrespro.ru> wrote:
Hello.

I've just uploaded ZSON extension on GitHub:

https://github.com/afiskon/zson

ZSON learns on your common JSONB documents and creates a dictionary
with strings that are frequently used in all documents. After that you
can use ZSON type to compress documents using this dictionary. When
documents schema evolve and compression becomes inefficient you can
re-learn on new documents. New documents will be compressed with a new
dictionary, old documents will be decompressed using old dictionary.

In some cases ZSON can save half of your disk space and give you about
10% more TPS. Everything depends on your data and workload though.
Memory is saved as well. For more details see README.md.

Please don't hesitate to ask any questions. Any feedback and pull
requests are welcome too!

--
Best regards,
Aleksander Alekseev

В списке pgsql-general по дате отправления:

Предыдущее
От: Edson Richter
Дата:
Сообщение: Re: Installing pgAdmin 4 in Oracle Enterprise Linux 7
Следующее
От: otar shavadze
Дата:
Сообщение: