# v0.1 Archive: Welcome to pg_mooncake (Delta Lake)

> Historical documentation archive for pg_mooncake v0.1 (USING columnstore + Delta Lake storage engine).

---

LLMS index: [llms.txt](/llms.txt)

---

> [!WARNING] Legacy `pg_mooncake v0.1` Archive (Delta Lake Engine)
> This page documents **`pg_mooncake v0.1`**, which used direct `CREATE TABLE ... USING columnstore` DDL and Delta Lake storage. Starting in `v0.2` and PGSTY's **`v0.3.0`** release, `pg_mooncake` uses [`moonlink`](/docs/intro/moonlink/) real-time columnstore mirrors (`CALL mooncake.create_table` + `USING mooncake`) and Apache Iceberg v2. For current documentation, see [Introduction](/docs/intro/) and [v0.1 vs v0.2 & v0.3](/docs/intro/0.1-vs-0.2/).

`pg_mooncake v0.1` is the first-generation PostgreSQL extension that added `USING columnstore` tables backed by Delta Lake and DuckDB (`pg_duckdb`) for analytical workloads.

![pg_mooncake Venn Diagram](/img/mooncake/pg_mooncake_intro.jpg)

## Key Features of `v0.1`

1. Transactional `INSERT`, `UPDATE`, and `DELETE` directly on `USING columnstore` tables
2. Columnar Parquet + Delta Lake metadata stored on local disk or S3 / R2 object storage
3. Vectorized analytical execution via embedded DuckDB
4. Seamless joins between regular PostgreSQL heap tables and `USING columnstore` tables

## `v0.1` Archive Contents

| Section | Pages |
|:---|:---|
| **Introduction** | [v0.1 Architecture](/docs/v0.1/architecture/) |
| **Getting Started** | [Get Started](/docs/v0.1/get-started/) · [Hello World](/docs/v0.1/hello-world/) · [Cloud Storage](/docs/v0.1/cloud-storage/) · [Neon Postgres](/docs/v0.1/neon-postgres/) |
| **Reference** | [Reference Overview](/docs/v0.1/reference/) · [Columnstore DDL](/docs/v0.1/columnstore-ddl/) · [Querying Outside Postgres](/docs/v0.1/columnstore-metadata/) · [Configurations](/docs/v0.1/configurations/) · [Load Data](/docs/v0.1/load-data/) · [Query External Files](/docs/v0.1/query-external-files/) · [Supported Queries](/docs/v0.1/query-shapes/) |
| **Use Cases** | [Data Archiving](/docs/v0.1/archiving/) · [Operational Analytics](/docs/v0.1/operational-analytics/) · [Data Warehousing](/docs/v0.1/warehousing/) |
{.wide .expand}

---

Section pages:

- [v0.1 Architecture (Delta Lake & USING columnstore)](/docs/v0.1/architecture/): Architecture of pg_mooncake v0.1: Table Access Method (USING columnstore), Parquet + Delta Lake metadata, and DuckDB read/write paths.
- [v0.1 Get Started](/docs/v0.1/get-started/): Historical v0.1 installation guide using Docker or source builds for PostgreSQL 14–17.
- [v0.1 Hello World (USING columnstore)](/docs/v0.1/hello-world/): Basic operations on v0.1 USING columnstore tables: CREATE TABLE, INSERT, UPDATE, DELETE, transactions, and joins.
- [v0.1 Cloud Storage (mooncake.create_secret)](/docs/v0.1/cloud-storage/): Configuring S3 and Cloudflare R2 buckets in pg_mooncake v0.1 using mooncake.create_secret and mooncake.default_bucket.
- [v0.1 on Neon Postgres](/docs/v0.1/neon-postgres/): Historical guide for enabling pg_mooncake v0.1 on Neon serverless PostgreSQL.
- [v0.1 Reference Overview](/docs/v0.1/reference/): Reference index for pg_mooncake v0.1 DDL, Delta Lake metadata catalogs, GUC parameters, data loading, and external file queries.
- [v0.1 Columnstore DDL (USING columnstore)](/docs/v0.1/columnstore-ddl/): Creating and dropping USING columnstore tables in pg_mooncake v0.1, supported data types, constraints, and default_table_access_method.
- [v0.1 Querying Columnstore Outside Postgres](/docs/v0.1/columnstore-metadata/): Inspecting mooncake.columnstore_tables and mooncake.data_files in pg_mooncake v0.1 and querying Delta Lake tables from Python Polars.
- [v0.1 GUC Configurations](/docs/v0.1/configurations/): Historical PostgreSQL GUC variables in pg_mooncake v0.1 (mooncake.default_bucket, maximum_memory, maximum_threads, enable_local_cache, enable_memory_metadata_cache).
- [v0.1 Load Data](/docs/v0.1/load-data/): Loading data into pg_mooncake v0.1 USING columnstore tables from Postgres tables, Parquet/CSV/JSON files, Iceberg/Delta tables, and HuggingFace.
- [v0.1 Query External Files](/docs/v0.1/query-external-files/): Querying external Parquet, CSV, JSON, Iceberg, and Delta Lake files in pg_mooncake v0.1 using mooncake.read_parquet, mooncake.read_csv, and mooncake.read_json.
- [v0.1 Supported Queries & Query Shapes](/docs/v0.1/query-shapes/): Analytical query patterns, unsupported PostgreSQL functions, and DuckDB function placeholders in pg_mooncake v0.1.
- [v0.1 Data Archiving](/docs/v0.1/archiving/): Historical v0.1 pattern for moving old rows from heap tables into a USING columnstore archive table.
- [v0.1 Operational Analytics (Trigger + pg_cron Staging)](/docs/v0.1/operational-analytics/): Historical v0.1 staging-table trigger and pg_cron pattern for near-real-time analytics before Moonlink was introduced.
- [v0.1 Data Warehousing & dbt](/docs/v0.1/warehousing/): Historical v0.1 guide for daily aggregation pipelines and dbt integration using default_table_access_method = 'columnstore'.

---

Backlinks:

- [v0.1 vs v0.2 & v0.3](/docs/intro/0.1-vs-0.2/)