We just switched to DuckDB from Postgres to analyze AWS billing data and wrote u... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

epberry on Feb 10, 2023 | parent | context | favorite | on: DuckDB – An in-process SQL OLAP database managemen...

We just switched to DuckDB from Postgres to analyze AWS billing data and wrote up our experience, https://www.vantage.sh/blog/querying-aws-cost-data-duckdb

Arguably Postgres was never the right tool to use for this analysis but nonetheless I was surprised at how much faster DuckDB was.

thewisenerd on Feb 10, 2023 [–]

ha! i'm using duckdb for a similar use-case.. plotting 18-month aggregates take less than 2 seconds.. vendor only provides data for the last 3 months (through the web portal).

(i'm "only" working with 30 million rows though)

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact