Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Taking advantage of more partitioning?
I have read and understand why there is a maximum to the number of partitions with Vertica but I'm still wondering if there isn't another way I can take advantage of the distribution of my data. Basically my data is distrubted by year but also by customerID. There is about 20 years worth of data in my database for approximately 100 customers. At the moment I'm only partitioning on year which has resulted in 20 partitions. But the data is always accessed for a specific customer so it's very easy to further partition by customerID which would result in 2000 partitions. This obviously won't work with Vertica due to the hard limits but is there another way? Perhaps I can create a projection for each customer/year? Would this be a good idea?