Re: using multiple partitions for a single table

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