The documentation says having too many partitions will end up being unproductive as it will cause the optimizer to examine all the tables for query planning. So I am wondering what's a reasonable upper limit?
If I was to partition a table by day I would have 365 tables per year. Is that too many? What if I used a different criteria that would cause a thousand tables?
Does anybody have experience with huge number of partitions if so where did you start running into trouble?