What can Postgres learn from DuckDB?
summary
DuckDB is an in-process analytics engine that claims far faster analytics than Postgres on ClickBench and can read CSV/Parquet/Arrow directly from S3 or HTTP. It adds instant SQL (live sampling and autocomplete), lightweight columnar storage in 120k row groups with run-length/dictionary compression, and morsel-driven parallelism (2000-row batches for cache-friendly execution). It also supplies a package manager and dynamic C extensions so new file systems and FDW-like connectors install and update without SQL bootstrap.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 1:19What is DuckDB
- 5:32Ease of use in DuckDB
- 10:16Friendly SQL and generic types
- 12:03Performance optimizations
- 16:56Extensibility in DuckDB
- 20:09Summary and resources
related talks
24mpg_duckdb: Ducking awesome analytics in Postgres
40mDuckDB: Harnessing in-process analytics for data science and beyond
19mIn-Process Analytical Data Management with DuckDB
28mAnalyze data easily with duckdb - and the implications on data architectures
01h 02mAnalytics for not-so-big data with DuckDB
34mData Wrangling with DuckDB
27mIn Process Analytical Data Management with DuckDB
25mA quack of all trades: DuckDB, a versatile analytical database to keep in your toolkit