On Fri, 2006-10-20 at 12:27 -0400, Tom Lane wrote:
> > This was a direct port from a big fat table. I agree, I'm not
> convinced that
> > the partial indexes will buy me much, but this box is so IO bound
> that the
> > planner overhead my just offset the needing to IO bigger indexes.
>
> Well,
On Friday 20 October 2006 09:27, Tom Lane wrote:
> Darcy Buskermolen <[EMAIL PROTECTED]> writes:
> > Yes CE is on (you can see it in the session paste). The other child
> > tables have simular CHECK's of type=2, type=3, type=4 and so on.. 1 for
> > each of the 30 tables.
>
> [ looks again... ] Oh,
Darcy Buskermolen <[EMAIL PROTECTED]> writes:
> Yes CE is on (you can see it in the session paste). The other child tables
> have simular CHECK's of type=2, type=3, type=4 and so on.. 1 for each of the
> 30 tables.
[ looks again... ] Oh, here's your problem:
type | smallint
On Friday 20 October 2006 08:26, Tom Lane wrote:
> 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 yo
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
> db=# \d s_ps.tbl_ps_type_1
> Table "s_ps.tbl_ps_type_1"
...
> Check constraints:
> "tbl_ps_typ_1_type_check" CHECK (type = 1)
> Inherits: tbl_ps
...
> myyearbook=# EXPLAIN ANALYZE SELECT uid FROM tbl_ps WHERE
> type = 1 and
> normalized_text='bush';
>
>
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. As you can see by the plan, it figures that there
is at least 1 rows in each partition (Which there is not). Also
