Tom,
On 7/22/05 3:32 PM, "Tom Lane" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
