Re: smart or dumb partition?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: smart or dumb partition?
Дата
Msg-id 407d949e0908071644h7b33998flf9bab9b631c431ad@mail.gmail.com
обсуждение исходный текст
Ответ на smart or dumb partition?  (Bob Gobeille <bob.gobeille@hp.com>)
Ответы Re: smart or dumb partition?
Список pgsql-general
On Sat, Aug 8, 2009 at 12:27 AM, Bob Gobeille<bob.gobeille@hp.com> wrote:
> I gather from rtfm that it is typical to set up partitions so that the
> "master" table has no records.  But from my understanding of partitions and
> doing some tests, I don't see any reason that has to be.  So I'm wondering
> if I'm missing some subtle (or not so subtle) point about partitions?

It's purely a convenience issue. Any child partition can be removed
later, The parent will be a pain if you ever want to remove it from
the partitioning structure.

--
greg
http://mit.edu/~gsstark/resume.pdf

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: psql and Emacs on Windows
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: 2nd call for papers (PostgreSQL West)