| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Markus Schiltknecht" <markus(at)bluegap(dot)ch> |
| Cc: | "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "Gregory Stark" <stark(at)enterprisedb(dot)com>, "NikhilS" <nikkhils(at)gmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Auto Partitioning |
| Date: | 2007-04-06 19:26:54 |
| Message-ID: | 1175887614.3623.501.camel@silverbirch.site |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2007-04-06 20:06:06 | Re: Fate of pgsnmpd |
| Previous Message | Stefan Kaltenbrunner | 2007-04-06 19:14:29 | Re: Fate of pgsnmpd |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zdenek Kotala | 2007-04-06 21:29:55 | Re: [PATCHES] Fix for large file support |
| Previous Message | Richard Troy | 2007-04-06 19:02:48 | Re: Auto Partitioning |