Hey,
I'm trying to understand when using hash partitions can be better than using list partition when the partition column is bigint. I understand that If my partition column has many distinct values then If I'll use a list partitions I might have a lot of partitions. On the other hand, with hash partitions on that column I can combine a few partition keys to the same partition.
I understand that maintenance on more partitions is harder but the performance with list partition should be faster because we will have less records in each table. Is there any reason hash partitions will be better than list partitions in aspect of peromance ?
Thanks !