I am getting incredibly slow performance on a table with 30k partitions, is that normal?

we were observing poor performance as a result of overpartitioning our table. how large are the files in each of those partitions? performance suffers when you have too many small files

Yeah I figured the same, the source table that I created it from had also the same amount of partitions, but that one was 60tb. This one is way less, so i've removed one partition by column that blew up all the partitions