DuckDB Extensions vs Postgres

DuckDB 61,228 keeps its core small and loads the rest as extensions. This section uses two of them, then runs the same six queries on PostgreSQL 18.6 1,289 and DuckDB 1.5.5 over the same sales mart to see where each engine wins and why.

Subsections

• Extensions
• httpfs and Object Storage
• The postgres Extension
• Benchmark Setup
• Timings on the Four-CPU Host
• Why Each Engine Wins
• PostgreSQL or DuckDB?