On Fri, 2007-04-06 at 16:08 +0200, Markus Schiltknecht wrote:
> Simon Riggs wrote:
> > i.e. if we have partitions for each year (2001, 2002, 2003 2004, 2005,
> > 2006, 2007) AND we have already proved that 2005 is excluded when we
> > have a WHERE clause saying year >= 2006, then we should be able to use
> > the ordering to prove that partitions for 2004 and before are also
> > automatically excluded.
>
> Provided you've set up the right constraints, the current
> constraint_exclusion feature does exactly that, no?
The end result yes, the mechanism, no.
> > I'll think some more about the Merge node, but not right now.
> --
> Simon Riggs
> EnterpriseDB http://www.enterprisedb.com
>