3 ms·
Why Postgres? DuckDB is column-based and Postgres is row-based. For analytics workloads, I’m having a hard time thinking of a scenario where Postgres wins in te
by physicles 3y ago
Why Postgres? DuckDB is column-based and Postgres is row-based. For analytics workloads, I’m having a hard time thinking of a scenario where Postgres wins in terms of performance.
If your data is too big to fit into DuckDB, consider Clickhouse, which is also column-based and understands standard SQL.
- cmiles74 3y agoI hear you. I was thinking something like "they don't have that much data anyway." For sure, there are better choices.