| From: | "Luke Lonergan" <llonergan(at)greenplum(dot)com> |
|---|---|
| To: | "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "NikhilS" <nikkhils(at)gmail(dot)com> |
| Cc: | "Peter Eisentraut" <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Auto creation of Partitions |
| Date: | 2007-03-07 15:23:40 |
| Message-ID: | C214432C.28B7C%llonergan@greenplum.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Simon,
On 3/7/07 5:26 AM, "Simon Riggs" <simon(at)2ndquadrant(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2007-03-07 15:49:16 | Re: GIST and TOAST |
| Previous Message | Tom Lane | 2007-03-07 15:13:55 | Re: PostgreSQL - 'SKYLINE OF' clause added! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-03-07 15:52:22 | Re: Auto creation of Partitions |
| Previous Message | Alvaro Herrera | 2007-03-07 14:58:32 | Re: Auto creation of Partitions |