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

Reply via email to