Deploy pg_duckdb
DuckDB powered Postgres for analytics
pg_duckdb
Just deployed
/var/lib/postgresql/data
Deploy and Host pg_duckdb on Railway
pg_duckdb is a PostgreSQL extension that integrates DuckDB's high-performance, columnar-vectorized analytics engine directly into PostgreSQL.
It enables seamless execution of analytical queries, supports querying data lakes (Parquet, CSV, JSON, Iceberg, Delta Lake) from cloud storage, and integrates with platforms like MotherDuck for cloud analytics.
About Hosting pg_duckdb
Hosting pg_duckdb involves deploying a PostgreSQL instance with the pg_duckdb extension enabled.
This allows you to leverage DuckDB's analytics capabilities within PostgreSQL, enabling high-speed queries on both local tables and external data lakes without data export.
The extension accelerates analytical workloads, supports modern data formats, and can integrate with cloud platforms like MotherDuck for scalable compute.
Common Use Cases
- Analytical Queries: Accelerate aggregations, window functions, and complex JOINs on PostgreSQL tables using DuckDB’s engine.
- Data Lake Integration: Query Parquet, CSV, JSON, Iceberg, and Delta Lake files directly from S3, GCS, Azure, or R2 without loading data into PostgreSQL.
- Hybrid Workloads: Combine OLTP (PostgreSQL) and OLAP (DuckDB) in a single environment for mixed workloads.
- ETL Pipelines: Transform and load data at scale by joining PostgreSQL tables with external data sources.
Dependencies for pg_duckdb Hosting
- PostgreSQL: 18.
Deployment Dependencies
Implementation Details
For cloud integration with MotherDuck:
MOTHERDUCK_TOKEN=
To force DuckDB execution for all queries:
SET duckdb.force_execution = true;
Why Deploy pg_duckdb on Railway?
Railway is a singular platform to deploy your infrastructure stack. Railway will host your infrastructure so you don't have to deal with configuration, while allowing you to vertically and horizontally scale it.
By deploying pg_duckdb on Railway, you are one step closer to supporting a complete full-stack application with minimal burden. Host your servers, databases, AI agents, and more on Railway.
Template Content
pg_duckdb
pgduckdb/pgduckdb:18-main
