In Postgresql, having an append only table like that and using a "window" for queries would lead to very bad performance as the whole table would have to be scanned for the window function to work. And that could be terrible when you have hundred of thousands of rows.
I'm wondering if the situation is different with clickhouse? Or if it is just that no one cares as your requests to clickhouse are supposed to be less frequent and so it is not a problem if the request takes several minutes to complete?