I've been working with partitions (I have split my table in around 3000 partitions), and if i did some like this
SELECT * FROM my_parent_table WHERE some_value_in_which_partitioned_my_table in (34, 36, 48) constraint_exclusion works, (looking EXPLAIN, I can see that in planner only check the partition_table with CHECH id in 34, 36 and 48. Great! But if I increase the amount of ids, constraint_exclusion don't work. SELECT * FROM my_parent_table WHERE some_id in (34, 36, 48, 65, ... 234, 310) (in total, 101 different ids) When i do a query like that, EXPLAIN show me that ALL the partitioned tables (3000) are checked (and, of course, the Query is too slow) What is happening?
