I partitioned some tables over the weekend by month using a date field as the partitioning column.Table inheritance was used and all indexes on the parent were created on the partitions.constraint_exclustion = partition.
My question is, are partitions really getting pruned or are locks showing up just due to inheritance.
In order to know that a partition can be pruned, you have to know what the check constraint on it is. In order to know that, you have to lock the table so that the constraint can't change while you look at it. So you could say that it is just due to inheritance.