If integration with PostgreSQL is not a requirement, I would suggest looking at QuestDB[1] for the best performing open-source timeseries database currently on the market.
[1] https://questdb.io/blog/2021/07/05/comparing-questdb-timesca...
[1] https://questdb.io/blog/2021/07/05/comparing-questdb-timesca...