Clickhouse 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

Clickhouse 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.