Crunchy Data Warehouse: Postgres with Iceberg for High Performance Analytics

Crunchy Data has introduced Crunchy Data Warehouse, a high-performance analytics database built on PostgreSQL, designed to enhance analytical capabilities while maintaining compatibility with existing PostgreSQL features. This new offering integrates Apache Iceberg, allowing users to create, manage, and query Iceberg tables stored in S3, enabling efficient analytics on large datasets. The architecture supports ACID transactions across both operational and analytical tables, facilitating seamless data movement and consistency. Performance improvements are significant, with claims of over 10x better performance in TPC-H queries compared to standard PostgreSQL. Users can easily import and export data from S3 and utilize various file formats, including CSV and Parquet. The system is designed to be user-friendly for those familiar with PostgreSQL, requiring minimal additional learning. Crunchy Data Warehouse also supports advanced features like materialized views, vacuuming for data compaction, and integration with external tools. It is available as a managed service on AWS through Crunchy Bridge, with plans for on-premises deployment in the future. Overall, Crunchy Data Warehouse aims to simplify data warehousing while providing robust analytical capabilities.

- Crunchy Data Warehouse enhances PostgreSQL with Iceberg for improved analytics.

- It supports ACID transactions across operational and analytical tables.

- Performance is significantly improved, with claims of over 10x faster query execution.

- Users can easily import/export data from S3 and work with various file formats.

- The service is available as a managed solution on AWS, with future on-premises options.