You may already have looked into this. But there are postgres extensions that implements columnar stores. One of these is the following -> https://pgxn.org/dist/cstore_fdw/ which is developed by the reputable Citus.
The reason for suggesting this in the first place is that I saw that there were some issues related to clickhouse -> https://github.com/plausible/analytics/issues/301