When it comes to Postgres extensions for columnar storage, I like how Citus [1] handles the more general problem of columnar tables instead of focusing just on "hypertables" which necessarily must have a time column as primary key.

[1] https://github.com/citusdata/citus?tab=readme-ov-file#creati...