A PostgreSQL extension that compresses JSONB data using a shared dictionary of frequent strings, saving disk space and memory.
ZSON is a PostgreSQL extension that provides transparent compression for JSONB data. It solves the problem of JSONB's storage inefficiency by building a shared dictionary of frequent strings from your actual data, reducing disk space and memory usage while maintaining full compatibility with PostgreSQL's JSONB functionality.
Database administrators and developers using PostgreSQL with large volumes of JSONB data who need to optimize storage and improve performance without changing their application code.
Developers choose ZSON because it offers a seamless, drop-in compression solution specifically tailored for JSONB, with the ability to learn from real data patterns and adapt to schema changes over time, unlike generic compression methods.
ZSON is a PostgreSQL extension for transparent JSONB compression
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Acts as a drop-in type for JSONB, so existing queries and applications work unchanged without any code modifications.
Learns from actual JSONB documents to build shared dictionaries of frequent strings, optimizing for real-world usage patterns and potentially saving up to half the disk space.
Supports creating new dictionaries as JSON schemas evolve, allowing gradual migration without downtime or application disruption.
Can reduce disk usage and improve transactions per second (TPS) by up to 10%, while also saving memory in some workloads, as noted in benchmarks.
Requires users to train dictionaries on data subsets and manage re-learning processes, adding operational overhead compared to automatic compression solutions.
Cannot be installed in PostgreSQL schemas other than public, restricting deployment flexibility in databases using custom schemas.
New dictionaries take about a minute to be recognized due to caching, causing a lag in compression adaptation after schema changes.