Re: Get partition name for specific date

[Jan Bromberger]

Hi Rick,

thanks for the good idea.

As I am not experienced with partitioning, I am thankful for your opinion about the number of partitions. I chose 92 because that's the max number of days we keep the historical data. The data set is quite huge for my commodity hardware (10M rows per day). And I have to import them quite fast. Fortunately, most of my queries only require data from one day, a few require data from two dates. So I thought it would be a good way to help keeping the whole index or even data set in memory by using this granular partitioning. It seems to work good for me up until now. What are your worries about having many partitions?

Kind regards
Jan