Hey @User welcome to the group 🙂
Yeah, you are right - we have seen Clickhouse to be less resource intensive to start with - so you should be able to start with that. And we have tested Clickhouse to scale to 50k rps, so this should take care of your needs for good time