smart or dumb partition?

Поиск
Список
Период
Сортировка
От Bob Gobeille
Тема smart or dumb partition?
Дата
Msg-id F5CEDC4A-6B50-4AFD-8705-FD09828A0B66@hp.com
обсуждение исходный текст
Ответы Re: smart or dumb partition?
Список pgsql-general
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?  I'd like to have the master table contain all
my records except those that have very specific (and unique) criteria:

CREATE TABLE master (
   master_pk serial NOT NULL,
   myint          integer);

CREATE TABLE master_1 (
   CHECK (myint =1)
) INHERITS (master);


INSERT INTO master (myint) VALUES (2);
INSERT INTO master (myint) VALUES (3);
INSERT INTO master_1 (myint) VALUES (1);

Is there anything wrong with this?  It seems to work well but I am
concerned that I may be missing something since the docs say "<the
master> will contain no data".

Thanks,
Bob Gobeille
bobg@fossology.org

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Make check fails on 8.3.7
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: psql and Emacs on Windows