> good candidates for Timescales

By this i assume you want columnar access along time dimension.

There are a bunch of columnar options out there ( timescale being one). you can operate hybrid row + column access.

https://www.citusdata.com/blog/2021/03/06/citus-10-columnar-...

https://swarm64.com/post/postgresql-columnstore-index-intro/