My use-case is IoT devices sending data, and I'd want to keep the eg last 6 months of data for review, and some agregates, and archive + delete older data I wa

My use-case is IoT devices sending data, and I'd want to keep the eg last 6 months of data for review, and some agregates, and archive + delete older data I was going to go with Timescaledb for "simplicity" (eg having a single database) would Postgres+Clickhouse be indicated for this?