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.

The universal columnar format and multi-language toolbox for fast data interchange and in-memory analytics.

Apache Arrow defines a language-independent columnar memory format for flat and hierarchical data, organized for efficient analytic operations on modern hardware like CPUs and GPUs. The Arrow memory format also supports zero-copy reads for lightning-fast data access without serialization overhead.

• Apache Arrow @ GitHub.
• arrow-rs @ GitHub.

Related contents:

• Fast columnar JSON decoding with arrow-rs @ arroyo.
• I spent 6 hours learning Apache Arrow: Overview @ Data Engineer Things's Medium.

Zero-ETL data analytics with Postgres.

Simple and cost-effective cloud analytics platform automatically synced with your data sources.

BemiDB is a Postgres read replica optimized for analytics. It consists of a single binary that seamlessly connects to a Postgres database, replicates the data in a compressed columnar format, and allows you to run complex queries using its Postgres-compatible analytical query engine.

• BemiDB @ GitHub.