Re: using multiple partitions for a single table

Поиск
Список
Период
Сортировка
От Taher H. Haveliwala
Тема Re: using multiple partitions for a single table
Дата
Msg-id 20010908075523.27504.qmail@web13003.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: using multiple partitions for a single table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Thanks all for the suggestions.  I've decided to go
with LVM.  It would appear to be the most flexible
solution.

Taher

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "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


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: FINAL: Multi-User PostgreSQL usage SECURITY
Следующее
От: pmiranda@vm.com.br
Дата:
Сообщение: Re: pg_dump & windows (what a mess...!)