pg_mooncake

When Mooncake Labs paused public updates to pg_mooncake after v0.2.0, the extension was pinned to an earlier DuckDB 1.3.x / pg_duckdb snapshot and pgrx 0.12. Meanwhile, the PostgreSQL ecosystem moved forward to PostgreSQL 18, pgrx 0.19.3, and …

pg_mooncake 0.3.0 — released alongside duckdb_mooncake v0.0.2 and moonlink v0.0.1 — is the first release of the Mooncake real-time analytics suite maintained by PGSTY: pgsty/pg_mooncake v0.3.0 (MIT) pgsty/duckdb_mooncake v0.0.2 (MIT) pgsty/moonlink …

Thirteen months ago, we started Mooncake to bring the data intelligence stack that powers giants like OpenAI to every vibe-coded app and developer. From first prompt to IPO. Today, we’re joining forces with Databricks. The mission continues: make …

This technical overview assumes familiarity with Apache Iceberg, an open table format for analytical datasets. Iceberg is part of the general “Lakehouse” movement, where users: Store large datasets using open file formats (Parquet + Metadata) in …

Disclaimer: Your Postgres and Lakehouse are free and open too. You don’t need to be (or spend like) a giant to use them. Why Postgres + Lakehouse? Reason #1: If you believe in AI, this is the agent stack Agents need memory. Both working memory and …

Few areas in databases are hotter right now than extending Postgres to support analytics queries. This isn’t a particularly novel area either –– there have been plenty of attempts in the last decade: Here is what it means to our customers –– and why …

With v0.1, we proved that Postgres can deliver great analytics performance. Our approach combined two key pieces—DuckDB vectorized engine and a columnstore table—making pg_mooncake the only extension in Postgres that integrates both. The results …

Last week, we ran ClickBench on Postgres and ranked in the top 10. We showed that Postgres can be extended with pg_mooncake to support serious analytics workloads. In the announcement, we got a lot of questions on how pg_mooncake outperforms DuckDB …

TL;DR: We spent a few months optimizing PostgreSQL and made it to the Top 10 on ClickBench, a benchmark typically dominated by specialized analytics databases. What’s more, all compute is within Postgres, and all tables are managed directly by …

We announced pg_mooncake to the world on Day 60. Today, Day 131, pg_mooncake comes out of beta. pg_mooncake wins on ease and performance. So, we doubled down for v0.1. That’s it. The Easiest Way to Fast Analytics in Postgres With a native columnstore …

A thing that surprised us in the pg_mooncake launch was how much developers cared about ORMs for their analytical workloads. We saw two typical requests: “I have a bunch of Parquet files. I want full ORM support over them.” “I use Drizzle/Prisma for …

pg_mooncake launched in beta two months ago. It adds columnar storage and a vectorized engine to Postgres. Over the last two months, with our customers, we’ve realized we accidentally built the best serverless database for analytics. Here’s the …

pg_mooncake brings columnstore tables with DuckDB execution to Postgres for fast analytics. It supports transactional inserts, updates, and deletes, just like regular Postgres tables. Data is written with Delta Lake (and Apache Iceberg in v0.2+) …

We are Zhou, Cheng, and Pranav. And we’ve spent the last decade building databases at MemSQL (now SingleStore). We love complex systems, deep-tech engineering, and naturally – physics 🙂 Data systems, much like physics, are built on certain …