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

> > 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?
>
> CREATE COMPRESSION DICTIONARY public.simple_dict (
>     WORDS = my_json_schema
> );
>
> Then use the dictionary by referencing the DictionaryId within the
> datatype modifier, e.g. ZSON(357)
>
> That way we can use this for TEXT, XML, JSON etc.. as ZTEXT, ZXML, ZJSON
>
> So it seems like a generally useful thing to me.

Good idea!

What about evolving schema of JSON/JSONB/XML? For instance,
adding/removing keys in new versions of the application. UPDATE
COMPRESSION DICTIONARY?

--
Best regards,
Aleksander Alekseev