Postgres Optimized for Warehouse Workloads
Crunchy Bridge for Analytics
Connect Postgres to your cloud object storage for fast, vectorized analytical queries using a best in class production Postgres platform.
Query your data where it lives
Simplify your data management. No need for complex and costly data pipelines. Work with data where it lives in data lakes like S3. Giving you the flexibility to store with your data in CSV, Parquet or any data lake format while using familiar Postgres and SQL tools to build your data analytics.
Simple and fast analytics at your fingertips
1
Store your data in s3
Collect your data lake files in CSV, JSON, Parquet/GeoParquet, or Iceberg. This is cost effective, simple, and easy data storage. Easily move data to and from Postgres and your object store.
2
Create foreign tables
This allows the Postgres + DuckDB engine to connect to your remote data automatically detecting columns and data types.
3
Query from Postgres
Under the hood we’ll do all the work to vectorize the queries, make them fast, and cache what’s frequently accessed. Use materialized views or copy to pull data directly into Postgres.
Built for Performance
DuckDB + Postgres Hybrid
Get the stellar analytics performance of DuckDB along with all the capabilities and versatility of PostgreSQL in one box.
Vectorized Execution
Processes data in chunks and vectors to take advantage of modern CPU instructions that process multiple values at once.
Query Pushdown
Parts of the query plan can be pushed down into DuckDB for vectorized, parallel execution.
Caching
In the background, read and write files will also be automatically cached on NVMe drives for improved performance.
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 Bridge for Analytics stacks up, we ran the tests for you.
Spoilers
133x
Faster than Postgres
Clickbench Analytics Time Performed on Analytics-64*
4,104.33s
165.33s
60.88s
Seamlessly work with your data lake
A cloud native approach for modern data architectures
- Simple S3 integration
- CSV support
- Parquet support
- GeoParquet and spatial support
- Iceberg support
- Vectorized execution
Streamline your data stack
Reduce complexity, cut engineering time, and simplify your data analytics with Crunchy Bridge for Analytics. When we interviewed Third Iron about their move, they were thrilled with how simple it was to implement. Read more in their case study today.
