Re: A Guide to Constraint Exclusion (Partitioning)

Tom,

On 7/22/05 3:32 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> but the "scan all rows" will only happen if no index is provided on
> DateKey in the child tables. Otherwise the planner will probably
> select plans like this:
>
> -> Index Scan using i1 on sales_jan_dateitemoutlet
> sales_dateitemoutlet (cost=0.00..5.98 rows=1 width=0)

Good point.

> So at the moment I'm feeling a bit dubious about the real value.

What about the need to run DML against the partition master? Partitioning
itself is a big deal to BI/DW users, and to make it really usable will
require that DML be automatically applied based on the mapping of partition
master to the partitions. Does the CE strategy help with the implementation
of automated DML?

- Luke