> > What is really needed is a data structure that allows range
> > to be accessed more efficiently. This could make adding partitions
> > deciding in which partition a specific value goes an O(logN)
> I think we need to re-evaluate the inheritance mechanism for 
> partitioning and implement something much closer to the 
> storage layer, similar to Oracle.
> Having the constraint exclusion occur in the planner is not 
> flexible enough to allow more advanced solutions.

Whoa, do you have anything to back that up ?
You would need to elaborate what you actually mean, but I think it is
Sure, the constraint technique can be further extended (e.g. during
runtime), but imho the approach is very good.


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?


Reply via email to