From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | David Fetter <david(at)fetter(dot)org> |
Cc: | u235sentinel <u235sentinel(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Auto-extending table partitions? |
Date: | 2010-01-06 17:13:08 |
Message-ID: | 603c8f071001060913k17b53272q979e9fc17097425e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
>>
>> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jon Erdman | 2010-01-06 17:16:48 | Re: Fwd: [HACKERS] Closing out CommitFest 2009-11 |
Previous Message | Jon Erdman | 2010-01-06 17:12:35 | Re: Fwd: [HACKERS] Closing out CommitFest 2009-11 |