Re: Auto-extending table partitions?

Adding on to this use case:
what do we do when we reach end of year?
Probably auto-archive as per weekly, monthly , quarterly or yearly tables?

On Thu, Jan 7, 2010 at 1:14 AM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:

> On 1/6/10 9:13 AM, Robert Haas wrote:
> > On Wed, Jan 6, 2010 at 12:06 PM, David Fetter <david(at)fetter(dot)org> wrote:
> >> On Tue, Jan 05, 2010 at 08:50:25PM -0700, u235sentinel wrote:
> >>> Robert Haas wrote:
> >>>> Getting full?
> >>>>
> >>>> ...Robert
> >>>>
> >>> Ok. Bad analogy. We have the tables setup to write data according
> >>> to the month it was loaded. We have a December table, a January
> >>> table and so on. Basically following the examples given on the 8.4
> >>> web site.
>
> FWIW, our roadmap is to add a 2nd type or partitioning which would be on
> the sub-table level and much more automated for that reason.
>
> --Josh Berkus
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

--
Chetan Sutrave
http://www.enterprisedb.com