Darcy Buskermolen <[EMAIL PROTECTED]> writes: > I have a setup in which a table has been partitioned into 30 partitions on > type (1 -30), however no matter what I do i can't make the planner try to use > constraint exclusion on it.
Do you have constraint_exclusion turned on? What are the check constraints on the other children of tbl_ps? This example doesn't really show whether the planner is misbehaving or not. The multiple-partial-index setup on tbl_ps_type_1 looks pretty silly to me... it seems unlikely to buy anything except extra planning overhead. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster