Re: ZSON, PostgreSQL extension for compressing JSONB - Mailing list pgsql-general

From Vitaly Burovoy
Subject Re: ZSON, PostgreSQL extension for compressing JSONB
Date
Msg-id CAKOSWNkmw-xOK7X2+psSncf__93dUm2L3E5ZycZTyHra1LMGXg@mail.gmail.com
Whole thread Raw
In response to Re: ZSON, PostgreSQL extension for compressing JSONB  (Dorian Hoxha <dorian.hoxha@gmail.com>)
List pgsql-general
On 10/4/16, Dorian Hoxha <dorian.hoxha@gmail.com> wrote:
> On Tue, Oct 4, 2016 at 5:34 PM, Aleksander Alekseev <a.alekseev@postgrespro.ru> wrote:
>> Hello, Simon.
>>
>> Thanks for you interest to this project!
>>
>> > Will you be submitting this to core?
>>
>> I could align ZSON to PostgreSQL code style. I only need to run pgindent
>> and write a few comments. Do you think community would be interested in
>> adding it to /contrib/ ? I mean doesn't ZSON solve a bit too specific
>> problem for this?
>
> ~everyone wants lower data storage and wants some kind of compression.
> Can this be made to automatically retrain when analyzing (makes sense?)?
> And create a new dictionary only if it changes compared to the last one.

ANALYZE does not walk through all the table and does not change its records.
Creating a new dictionary for compressing purposes supposes updating
rows of the original table to replace entries to references to a
dictionary.

--
Best regards,
Vitaly Burovoy


pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: PGConf.Asia and visa
Next
From: PHANIKUMAR G
Date:
Subject: Re: postgres failed to start from services manager on windows 2008 r2