29 ms·
I will investigate Clickhouse. It is probably an even better solution that BigQuery when you have a lot of data and have a lot of queries.
by bhouston 2y ago
I will investigate Clickhouse. It is probably an even better solution that BigQuery when you have a lot of data and have a lot of queries.
- atombender 2y agoClickhouse is amazing. So is Postgres, but CH excels at its particular use case where Postgres does not. While these new Postgres extensions will make Postgres more competitive, CH is built from the ground up for these kinds of analytics workloads in a way that Postgres isn't, e.g. in terms of scalable data ingestion. CH also has a rich set of features like materialized views, aggregate function types, and dictionaries, none of which have counterparts in Postgres of these extensions.