Marco Slot
Software imagineer @ Crunchy Data
Marco works at Crunchy Data, where he designs and implements advanced data management products and features by extending PostgreSQL. He currently leads the development of Crunchy Data Warehouse, a modern PostgreSQL OLAP store built using DuckDB and a constellation of PostgreSQL extensions. Marco spent much of the past decade working on Citus (distributed PostgreSQL) and other PostgreSQL extensions, first as a founding engineer at Citus Data and later at Microsoft after Citus Data was acquired. Before Citus Data, Marco helped create Amazon CloudFront and Route 53 at AWS. He also obtained a PhD from Trinity College Dublin, and an MSc from VU Amsterdam, both in distributed systems.
POSETTE 2025 Talk
Building a PostgreSQL data warehouse
PostgreSQL is designed as an operational database. The planner, executor, storage layer and other architectural aspects are all optimized for running a high rate of transactions.
Most organizations use a variety of other platforms for analytics, but none are as versatile as PostgreSQL. Integrating operational and analytical database systems requires a huge amount of glue code to orchestrate ETL processes, and in the end you can do a lot less, except run faster analytical queries.
Last year, we set out on a journey to turn PostgreSQL into a modern data warehouse. One built using data lake table formats such as Iceberg, easy access to blob storage, high analytics performance, built using extensions. This talk is about what we learned along the way about turning PostgreSQL into a data warehouse.
Past Talks
-
Data-intensive PostgreSQL: Three ways to scale (POSETTE 2024)
-
The Distributed PostgreSQL problem & how Citus solves it (Citus Con 2023)
-
Citus 11: A look at the Elicorn's horn (Citus Con 2022)
Podcast Appearances
-
My Journey into Performance Benchmarking with Jelte Fennema-Nio & Marco Slot
-
Working in public on open source with Simon Willison & Marco Slot
Join the conversation
Use the hashtag #PosetteConf