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 <j...@agliodbs.com> wrote: > On 1/6/10 9:13 AM, Robert Haas wrote: > > On Wed, Jan 6, 2010 at 12:06 PM, David Fetter <da...@fetter.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Chetan Sutrave http://www.enterprisedb.com