Re: Constraint Exclusion (Partitioning) - Initial Review

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: pgsql-patches(at)postgresql(dot)org, bizgres-general <bizgres-general(at)pgfoundry(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)surnet(dot)cl>
Subject: Re: Constraint Exclusion (Partitioning) - Initial Review
Date: 2005-07-18 12:41:16
Message-ID: 1121690476.3970.611.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Mon, 2005-06-27 at 01:41 +0100, Simon Riggs wrote:
> I enclose a fully working implementation of Constraint Exclusion, a very
> basic form of Partitioning. Initial review is requested, to allow us all
> to assess what further work is required on this prior to Beta freeze.
>
> Patch against current cvstip; passes make check and all special tests.

It has been pointed out to me that the patch has a minor, yet basic
error in the planning. This has now been corrected in this patch.

It appears that my midnight-patch submission was not such a good idea
after all. My full and sincere apologies to anybody that tried and
failed on that patch. To err is human...

I have also now filled the gap for when all relations are excluded,
mentioned as question 1 in my original post.

I have now re-tested the patch against cvstip...
The special tests files are unchanged.

Performance tests and comments welcome.

Best Regards, Simon Riggs

Attachment Content-Type Size
partition2.patch text/x-patch 43.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-07-18 13:38:56 Re: Buildfarm failure analysis: penguin on 7.4 branch
Previous Message Jim Buttafuoco 2005-07-18 12:20:46 Re: Buildfarm failure analysis: penguin on 7.4 branch

Browse pgsql-patches by date

  From Date Subject
Next Message Rocco Altier 2005-07-18 16:21:44 Changes for AIX buildfarm
Previous Message Simon Riggs 2005-07-18 12:20:25 Re: Constraint Exclusion (Partitioning) - Initial Review