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.