Re: Auto-extending table partitions?

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: Auto-extending table partitions?
Дата
Msg-id 20100106170648.GL24648@fetter.org
обсуждение исходный текст
Ответ на Re: Auto-extending table partitions?  (u235sentinel <u235sentinel@gmail.com>)
Ответы Re: Auto-extending table partitions?  (Robert Haas <robertmhaas@gmail.com>)
Список 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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Streaming replication and postmaster signaling
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Auto-extending table partitions?