Manage, query and update iceberg tablesTransactions across operational and data lake tablesHighly performant analytical queriesNavigate, query, and manage your data lakeFlexibly import and export data to S3Seamlessly integrate with your existing data tools
in native Postgres

Crunchy Data Warehouse

A next-generation Postgres-native data warehouse. 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

Since the early days of Postgres, it's been modified to suit data warehousing needs. The analytics landscape has evolved, but Postgres solutions haven't kept up. Some have stretched Postgres beyond its core capabilities for OLAP, sacrificing performance. Others have created forks, resulting in fragmentation and loss of compatibility. We saw the need to build a modern Postgres data warehouse with true OLAP performance, modern open formats, and no forks.

Managed Iceberg tablesHigh performance analyticsQuery your data lakeFlexible data import/exportSeamless integrationsZero-ETL

What It Is

It's Postgres, not simply "Postgres-compatible," extended to perform efficiently on analytical workloads. Crunchy Data Warehouse extends Postgres with a vectorized query engine, parallel processing, and the ability to read and write to transactional tables that are backed by a data lake infrastructure.

Millisecond response timesData management flexibilityInfinite, compressed storageEasy data import/exportOpen-table formats (including Iceberg)Full Postgres feature set

Use Cases

The only limitation is your previous understanding of Postgres. With Crunchy Data Warehouse's extended capabilities, the Postgres you love becomes an excellent fit for analytics. With the expansion of workloads across the industry, it’s a great fit for:

Monitoring and telemetryInternet of Things (IoT)Web and app analyticsTime series dataAd networksOnline gamingObservability and metricsUser behavior analyticsGeospatial

Get Started

If you've used Postgres, you can use Crunchy Data Warehouse. Use the links below to get started today.

Sign Up NowQuick Start GuideDocumentationContact Us

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

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 datastore and compression with the functionality expected from a datalake house.

  • Local disk performance, cloud storage prices
  • Performance of an application database
  • Transactional & analytical processing
  • Cloud-optimized storage
  • Cost efficient

Simplify Your Data Stack without Compromising Performance

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

The Power of Postgres—Unlocked

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.

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.

Third IronCrunchy Data Warehouse

Streamline Your Data Stack

Reduce complexity, cut engineering time, and simplify your data analytics with Crunchy Data Warehouse. When we interviewed Third Iron about their migration, they were thrilled with how simple it was to implement.

Read Case Study

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

All the Goodies of Fully Managed Postgres

Backups

Fully managed at no cost. Restore to any point in time.

Disaster Recovery

Cross zone automated failover for groups that need rto in seconds.

Scale in Place

In place resizing for more memory or storage. Easily scale out with read replicas.

VPC Isolation

Isolated data plane with peering to your cloud network.

Database Insights

Key metrics to keep you in the know with what is happening with your database with monitoring included.

Querying & Collaboration

Get help every step of the way with our Postgres focused support team.

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 133x faster than Postgres.

Clickbench Analytics Time Performed on Warehouse - Standard-64*

4,104.33s

165.33s

60.88s

Postgres
Crunchy Data Warehouse (uncached)
Crunchy Data Warehouse (cached)

Learn More About Crunchy Data Warehouse

Contact Us