Crunchy Data Warehouse

A next-generation Postgres-native data warehouse, with full Iceberg support for fast analytical queries and transactions, built on unmodified Postgres to support the features and ecosystem you love.

Why we built it

Existing Postgres data warehouse solutions compromise OLAP performance or fork the codebase. Ours, however, offers true OLAP capabilities that maintain compatibility and leverage modern formats.

  • Managed Iceberg tables
  • High performance analytics
  • Query your data lake
  • Flexible data import/export
  • Seamless integrations
  • Zero-ETL

What it is

This is Postgres, not just "Postgres-compatible," extended and optimized for analytical workloads with a vectorized query engine, parallel processing, and data lake-backed transactional tables.

  • Millisecond response times
  • Data management flexibility
  • Infinite, compressed storage
  • Easy data import/export
  • Open-table formats
  • Full Postgres feature set

Use cases

The only limitation is your understanding of Postgres. Crunchy Data Warehouse extends Postgres beyond its traditional limits, making it an excellent analytics platform that's ready for modern workloads like:

  • Monitoring and telemetry
  • Internet of Things (IoT)
  • Web and app analytics
  • Time series data
  • Ad networks
  • Online gaming
  • Observability and metrics
  • User behavior analytics
  • Geospatial

Have it your way

Your data warehouse, anywhere you want it

Crunchy Postgres for Kubernetes

Cloud-native data warehouse on Kubernetes
  • Simple provisioning
  • Backups included
  • High availability
  • Scale from 1 to thousands of databases
  • Self-managed

Crunchy Bridge

Fully managed Postgres on your choice of cloud provider
  • Cloud agnostic (AWS, Azure, GCP)
  • Continuous protection
  • Backups included
  • Pay for what you use
  • The developer experience you want

Enterprise support

Crunchy Data Support included with all Crunchy Data Product subscriptions
Learn more

See it in action

Powerful analytics on Postgres

See how easy it is to query and analyze your data with familiar Postgres commands. No new syntax to learn—just faster results at any scale.

  • Easily query raw data files in your data lake
  • Flexibly import and export data between Postgres and S3
  • Seamlessly integrate with your existing data tooling
  • Create, manage, and query data in both Postgres and Iceberg tables
View more

It’s just Postgres

Bridge the gap between OLTP and OLAP in a single Postgres environment.

  • Full SQL support
  • Transactions (DDL and data)
  • Version rollback capabilities
  • Schema migration
  • Datalake & open-table file formats

Reduce data management costs

Columnar storage and compression with full datalake house capabilities.

  • Local disk speeds at cloud storage costs
  • Performance of an application database
  • Transactional & analytical processing
  • Cloud-optimized storage
  • Cost efficient

Simplify your data stack

Deploy and scale on cloud or bare metal with Crunchy Postgres for Kubernetes.

  • Postgres for applications
  • Postgres for data lakes
  • Postgres syntax teams already use
  • Vectorized execution engine
  • Parallel processing capabilities

Postgres-native analytics

Unlock the power of Postgres

We've built upon PostgreSQL's robust foundation to create a seamless analytics experience. Leverage your PostgreSQL knowledge while gaining powerful new capabilities for handling large-scale analytical workloads.

Extensive PostgreSQL ecosystem

Leverage popular extensions like pg_cron and pg_stat_statements while handling both OLTP and OLAP workloads.

Zero learning curve

If you know Postgres, you already know how to use Crunchy Data Warehouse. Same syntax, same tools, new possibilities.

Advanced query optimization

Leverage vectorized execution and parallel processing capabilities to handle complex analytical queries with unprecedented speed.

Expertly engineered

Modern data architecture

Built for cloud-native environments, our architecture combines the best of modern data technologies to deliver unprecedented flexibility and performance.

Data lake

Designed to handle the most demanding analytical workloads for data scientists, developers and DBAs working with large-scale data systems.

Optimized storage format

Columnar data stored in a columnar format and queried using a vector execution engine, all within the same Postgres environment.

We looked into various data pipelines and had a plan in place, but when Crunchy Data Warehouse was released, it solved our problem without all the complexity we were expecting.

Karl Becker

Co-Founder, Third Iron

Case study

Streamline your data stack

Reduce complexity, cut engineering time, and simplify your data analytics with Crunchy Data Warehouse. Third Iron found their migration remarkably straightforward

Read more

Same queries in a fraction of the time

If you're curious how Crunchy Data Warehouse stacks up, we ran the tests for you. It's 133 times faster than Postgres.

4,104.33s

165.33s

60.88s

Clickbench analytics time performed on Warehouse-Standard-64*

Postgres
Crunchy Data Warehouse
Crunchy Data Warehouse (cached)

Contact Crunchy Data

Looking for more details or need assistance? Reach out to us and our expert team will gladly assist you.