Re: Auto-extending table partitions? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Auto-extending table partitions?
Date
Msg-id 603c8f071001060913k17b53272q979e9fc17097425e@mail.gmail.com
Whole thread Raw
In response to Re: Auto-extending table partitions?  (David Fetter <david@fetter.org>)
Responses Re: Auto-extending table partitions?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Wed, Jan 6, 2010 at 12:06 PM, David Fetter <david@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.
>>
>> I'm thinking it would be nice if there was a way to automatically
>> add the next month without having to script it all out.
>
> There's no good reason you can't add 5 years' worth of tables right up
> front.

Different people might want different naming conventions for those
tables, too.  We've heard this request before so maybe we should
consider it, but it seems like a lot of work for something that's not
too hard to code up for yourself, and can be handled much more
flexibly that way.

...Robert


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Auto-extending table partitions?
Next
From: Magnus Hagander
Date:
Subject: Re: [pgsql-www] tribble.postgresql.org - planned maintenance downtime