[dirtbag__dad]

OLAP conveniently not mentioned. Anyone have any suggestions for this?

We tried to get as much mileage as we could out of Postgres before we switched to clickhouse and it was night and day.

[hasperdi]

This. Postgres is slow for large inserts compared to eg. Clickhouse.

This slowness is mostly because of OLTP features

[dzonga]

why not use DuckDB ?

of course that depends on your workload etc - but for most cases duckDB should be efficient.