Simon,
On 3/7/07 5:26 AM, "Simon Riggs" <[EMAIL PROTECTED]> wrote:
> What is really needed is a data structure that allows range partitions
> to be accessed more efficiently. This could make adding partitions and
> deciding in which partition a specific value goes an O(logN) operation.
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.
- Luke
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
