Crunchy Data Warehouse: Postgres with Iceberg for High Performance Analytics

We are excited to release Crunchy Data Warehouse, a modern data warehouse for Postgres. Crunchy Data Warehouse combines Postgres with Iceberg, Parquet, and data lake formats for fast analytics queries and cost efficient storage.

 WHAT'S NEW 

PostGIS Day 2024 Summary

Crunchy Data hosted an online event for PostGIS on November 21st, 2024. Paul has a wrap up post discussing the highlights and themes throughout the day. A full playlist

Accessing Large Language Models from PostgreSQL

Paul shows you how to use a new OpenAI API extension for working with LLMs in Postgres.

A change to ResultRelInfo - A Near Miss with Postgres 17.1

A new point version was released on Nov 14th for 17.1, 16.5, 15.9, and others. This included an update to the Postgres ABI potentially breaking extensions. Craig digs into the change and what you need to know.

Easy Totals and Subtotals in Postgres with Rollup and Cube

Learn about easy subtotals with the GROUP BY ROLLUP and CUBE to get totals and subtotals across categories and date bins. 

Loading the World! OpenStreetMap Import In Under 4 Hours

Greg has a full OSM load for the entire world running in record time. He digs into turning and recent software and hardware updates that make a full planet run in less than 4 hours. 

Iceberg ahead! Analyzing Shipping Data in Postgres

Marco shows off how work with Iceberg and Postgres together in Crunchy Data Warehouse. He creates an Iceberg data set from AIS shipping data, batch loads public data daily, and then runs reports and maps from Postgres.

Postgres Partitioning with a Default Partition

Keith discusses the importance of having a default partition, how to monitor the default, and how to move rows to new child tables.

Smarter Postgres LLM with Retrieval Augmented Generation

As a follow up to Paul's last post on an OpenAI connector to Postgres, Paul shows you how to add new data for your LLM queries to make them more accurate.

8 Steps in Writing Analytical SQL Queries

Chris breaks down his approach to building out complex SQL step by step. 
 

 EVENTS 

Crunchy Data Events Page


American Meteorological Society Annual Meeting

Sunday, January 12 | New Orleans

Red Hat Summit Connect

Wednesday, January 15 | Zurich

DuckCon

Friday, January 31 | Amsterdam, Netherlands

Laracon EU

Tuesday, February 3 | Amsterdam, Netherlands

banner

Crunchy Data | 843-737-6045 | crunchydata.com

unsubscribe manage preferences