Re: using multiple partitions for a single table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: using multiple partitions for a single table
Дата
Msg-id 29225.999745066@sss.pgh.pa.us
обсуждение исходный текст
Ответ на using multiple partitions for a single table  ("Taher H. Haveliwala" <taherh24@yahoo.com>)
Ответы Re: using multiple partitions for a single table  ("Taher H. Haveliwala" <taherh24@yahoo.com>)
Список pgsql-admin
"Taher H. Haveliwala" <taherh24@yahoo.com> writes:
> Is it possible in postgres 7.1.3 to have a single
> table span multiple partitions?  Or is using RAID the
> only option?

RAID or LVM are the best scenario.  If you're really in a bind you
could manually move table segments to different partitions and set up
symlinks from the original location.  But this is a pain in the neck;
also, I would not recommend doing it while the postmaster is running.

            regards, tom lane

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

Предыдущее
От: "Chad R. Larson"
Дата:
Сообщение: Re: using multiple partitions for a single table
Следующее
От: Richard NAGY
Дата:
Сообщение: Need help or advices : databases and tables invisibles and not accessibles !