What can Postgres learn from DuckDB? (PGConf.dev 2025)
2025/06/13Presented by Jelte Fennema-Nio at PGConf.dev 2025 (https://2025.pgconf.dev)
DuckDB an open source SQL analytics engine that is quickly growing in popularity. There are three main reasons for this:
It is very fast at analytics workloads It is extremely extensible It has made some nice improvements to its SQL syntax This begs the question: What can Postgres learn from DuckDB? In this talk I'll discuss how Postgres could learn from some of the things that DuckDB did differently.
Related Videos
2025-06-12
pg_duckdb: Ducking awesome analytics in Postgres
Supercharge your Postgres analytics! This talk shows how the pg_duckdb extension accelerates your slowest queries instantly, often with zero code changes. Learn practical tips and how to use remote columnar storage for even more speed.
Talk
Sources
2025-06-02
Taming file zoos: Data science with DuckDB database files
Tame "file zoos" with DuckDB! This talk reveals how DuckDB seamlessly integrates with Python to read/write diverse files (CSV, Parquet), organize data efficiently, enable larger-than-memory analysis, and streamline your workflows.
Python
Talk
2025-04-23
Instant SQL Mode - Real Time Feedback to Make SQL Data Exploration Fly
Hamilton Ulmer shares insights from MotherDuck's Instant SQL Mode, exploring how real-time query result previews eliminate the traditional write-run-debug cycle through client-side parsing and DuckDB-WASM caching.
SQL
Talk
MotherDuck Features
