From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | u235sentinel <u235sentinel(at)gmail(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Auto-extending table partitions? |
Date: | 2010-01-06 17:06:48 |
Message-ID: | 20100106170648.GL24648@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
From | Date | Subject | |
---|---|---|---|
Next Message | Jon Erdman | 2010-01-06 17:12:35 | Re: Fwd: [HACKERS] Closing out CommitFest 2009-11 |
Previous Message | Tom Lane | 2010-01-06 16:58:08 | Re: Streaming replication and postmaster signaling |