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 > ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
