Re: Intentionally splitting data in a table across files.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Intentionally splitting data in a table across files.
Дата
Msg-id 27503.991845186@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Intentionally splitting data in a table across files.  ("Nick Fankhauser" <nickf@ontko.com>)
Ответы Re: Intentionally splitting data in a table across files.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-admin
"Nick Fankhauser" <nickf@ontko.com> writes:
> Does PostgreSQL support (or some day will support) "partitioned tables"?

It's not on anyone's radar screen AFAIK.

> Alternately, does anyone have an idea about how to address this need in a
> different way using existing tools?

Make a view that's a UNION of the component tables, plus rules that
cause inserts to go into the appropriate components.

            regards, tom lane

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

Предыдущее
От: "Nick Fankhauser"
Дата:
Сообщение: Intentionally splitting data in a table across files.
Следующее
От: Dave Stokes
Дата:
Сообщение: changes sequences to unique