Crunchy Data Warehouse, a Modern Postgres Analytics Platform for the Hybrid Cloud
Crunchy Data, the leading provider of trusted open source Postgres technology and products, today announces the availability of Crunchy Data Warehouse, a modern, high-performance analytics database built on PostgreSQL, for Kubernetes.
Crunchy Data Warehouse extends Postgres to support high-performance analytical workloads alongside operational database workloads, combining regular Postgres tables with fully transactional Iceberg tables. By seamlessly integrating the DuckDB query engine and other modern OLAP technologies, Crunchy Data Warehouse offers ultra-fast analytics within a native Postgres experience. The release of Crunchy Data Warehouse for Kubernetes brings the power of Apache Iceberg-based storage to private and hybrid cloud users through the automation and scalability of Kubernetes.
“Crunchy Data Warehouse is a modern developer-friendly data warehouse built on PostgreSQL,” said Craig Kerstiens, Crunchy Data Chief Product Officer. “By integrating Crunchy Data Warehouse with Crunchy Data’s Postgres Operator, we are able to provide a fully automated and scalable production-ready Crunchy Data Warehouse deployment with the flexibility of the user’s choice of infrastructure – whether that’s private cloud, hybrid cloud or public cloud.”
Crunchy Data Warehouse brings many ground-breaking new features to PostgreSQL deployed to Kubernetes, including:
- Managed Iceberg tables in PostgreSQL: Create, manage, query, and update Iceberg tables stored in S3 as easily as PostgreSQL tables.
- High performance analytics: Extends the PostgreSQL query planner to delegate parts of the query to DuckDB for vectorized execution. Delivers over 10 times the average performance of PostgreSQL on the TPC-H queries, and even greater improvements on many common query patterns.
- Query raw data files in your data lake: Easily query data files and directories stored in S3 or public URLs.
- Flexible data import/export: Load data directly from S3 into Iceberg or regular PostgreSQL tables, and write query results back to S3 to create advanced data pipelines.
- Seamless integrations: The Iceberg table format enables interoperability with a broad ecosystem of analytics tools, enabling Crunchy Data Warehouse to interface with tools like Apache Spark to directly query your tables in S3 storage.
Crunchy Data Warehouse uses extensions to stay current with the latest version of PostgreSQL. Users have the full benefit of the power of Postgres, extended with the benefits of Apache Iceberg based storage without sacrificing PostgreSQL features or losing compatibility with its ecosystem.