Crunchy Data has unveiled the latest iteration of its Crunchy Data Warehouse, now optimized for Kubernetes, which integrates the robust capabilities of Postgres-native Apache Iceberg. This release marks a significant advancement for users seeking high-performance analytics within a familiar PostgreSQL environment.
Enhanced Features for Modern Data Workloads
With this new offering, Crunchy Data Warehouse extends PostgreSQL’s functionality to accommodate both analytical and operational workloads. By merging traditional Postgres tables with fully transactional Iceberg tables, it provides a versatile solution for data management. The integration of the DuckDB query engine and other contemporary OLAP technologies allows for ultra-fast analytics, ensuring that users can leverage the full power of their data.
Craig Kerstiens, Chief Product Officer at Crunchy Data, emphasized the developer-friendly nature of the Crunchy Data Warehouse. “By integrating Crunchy Data Warehouse with Crunchy Data’s Postgres Operator, we are able to provide a fully automated and scalable production-ready deployment,” he noted. This flexibility allows users to choose their preferred infrastructure, whether it be private, hybrid, or public cloud.
Groundbreaking Features
The Crunchy Data Warehouse introduces several innovative features designed to enhance the PostgreSQL experience on Kubernetes:
- Managed Iceberg tables in PostgreSQL: Users can create, manage, query, and update Iceberg tables stored in S3 with the same ease as traditional PostgreSQL tables.
- High performance analytics: The PostgreSQL query planner has been extended to delegate portions of queries to DuckDB for vectorized execution, achieving over ten times the average performance on TPC-H queries and significant improvements on various common query patterns.
- Query raw data files in your data lake: Users can effortlessly query data files and directories located in S3 or accessible via public URLs.
- Flexible data import/export: The system allows for direct loading of data from S3 into Iceberg or regular PostgreSQL tables, as well as writing query results back to S3 to facilitate advanced data pipelines.
- Seamless integrations: The Iceberg table format supports interoperability with a wide range of analytics tools, enabling direct querying of tables stored in S3 using tools like Apache Spark.
By utilizing extensions, Crunchy Data Warehouse remains aligned with the latest PostgreSQL developments, ensuring that users benefit from the powerful features of Postgres while also enjoying the advantages of Apache Iceberg-based storage. This approach guarantees compatibility with the extensive PostgreSQL ecosystem, allowing for a smooth transition and integration.
Crunchy Data continues to position itself as a leader in the realm of open-source PostgreSQL technology, offering enterprises a reliable alternative to costly proprietary database solutions. With its commitment to innovation and support, Crunchy Data empowers organizations to build robust data infrastructures with confidence.
