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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Taher H. Haveliwala" <taherh24(at)yahoo(dot)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