Re: using multiple partitions for a single table - Mailing list pgsql-admin

From Taher H. Haveliwala
Subject Re: using multiple partitions for a single table
Date
Msg-id 20010908075523.27504.qmail@web13003.mail.yahoo.com
Whole thread Raw
In response to Re: using multiple partitions for a single table  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: FINAL: Multi-User PostgreSQL usage SECURITY
Next
From: pmiranda@vm.com.br
Date:
Subject: Re: pg_dump & windows (what a mess...!)