1000x Faster Analytics in Postgres. Postgres-native Data Warehouse.

pg_mooncake is a Postgres extension that adds columnar storage and vectorized execution (DuckDB) for fast analytics within Postgres. Postgres + pg_mooncake ranks among the top 10 fastest in ClickBench.

• pg_mooncake @ GitHub.

Fast, Simple and a cost effective tool to replicate data from Postgres to Data Warehouses, Queues and Storage.

PeerDB is an ETL/ELT tool built for PostgreSQL. We implement multiple Postgres native and infrastructural optimizations to provide a fast, reliable and a feature-rich experience for moving data in/out of PostgreSQL.

• PeerDB @ GitHub.

Related contents:

• Reliably Replicating Data Between PostgreSQL and ClickHouse Part 1 - PeerDB Open Source @ BenjaminWootton.com.

Ducking Simple Data Warehouse based on DuckDB.

• Your October Dose of Data - October 2024 @ Data Council.

The Cloud Operational Data Store. Use SQL to transform, deliver, and act on fast-changing data.

Materialize is a cloud-native data warehouse purpose-built for operational workloads where an analytical data warehouse would be too slow, and a stream processor would be too complicated.

Using SQL and common tools in the wider data ecosystem, Materialize allows you to build real-time automation, engaging customer experiences, and interactive data products that drive value for your business while reducing the cost of data freshness.

• Materialize @ GitHub.