pg_deltax: Apache-licensed time-series extension for PostgreSQL
DeltaX is a PostgreSQL extension designed for efficient time-series data management. It offers features like compression and columnar storage while maintaining compatibility with standard PostgreSQL functionalities. Although it ranks lower than specialized analytical stores, it excels in storing data within PostgreSQL itself.
- ▪DeltaX is an Apache-licensed extension for PostgreSQL that provides compression and columnar storage for time-series data.
- ▪It ranks higher than other PostgreSQL-based systems in benchmarks, despite being lower than specialized analytical stores like ClickHouse.
- ▪DeltaX supports faster data loading from Parquet files and offers a compression ratio of about 7× on specific datasets.
Opening excerpt (first ~120 words) tap to expand
DeltaX (δx) - Fast time-series extension for PostgreSQL DeltaX (δx) is a PostgreSQL extension offering compression and columnar storage for time-series data. It can be used as a pure open-source (Apache 2.0) alternative to TimescaleDB or as a PostgreSQL-native alternative to dedicated analytics stores like ClickHouse, when you'd like your data to stay in Postgres. δx stores the compressed columnar data in regular Postgres tables. It does not use its own storage format on disk. The advantage of this approach is that features like physical/logical replication, crash recovery, backups, and pg_dump work as for any other Postgres table.
…
Excerpt limited to ~120 words for fair-use compliance. The full article is at GitHub.