PgConf.Russia 2017 talks

ZSON, PostgreSQL extension for transparent JSONB compression

Alexander Alekseev
PostgresPro, Software Developer

Alexander is a programmer, OSS- and FP-enthusiast, contributor to PostgreSQL, FreeBSD and other open source projects. He is an author of the blog and one of regular speakers of podcast. Since 2015 year Alexander has been working at Postgres Professional company, dealing with PostgreSQL core development.

ZSON is a PostgreSQL extension for transparent JSONB compression. Compression is based on a shared dictionary of strings most frequently used in specific JSONB documents (not only keys, but also values, array elements, etc). In some cases ZSON can save half of your disk space and give you about 10% more TPS.