Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: using multiple partitions for a single table
Date
Msg-id 29225.999745066@sss.pgh.pa.us
Whole thread Raw
In response to using multiple partitions for a single table  ("Taher H. Haveliwala" <taherh24@yahoo.com>)
Responses Re: using multiple partitions for a single table  ("Taher H. Haveliwala" <taherh24@yahoo.com>)
List pgsql-admin
Tree view 
"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 by date:

Previous
From: "Chad R. Larson"
Date:
Subject: Re: using multiple partitions for a single table
Next
From: Richard NAGY
Date:
Subject: Need help or advices : databases and tables invisibles and not accessibles !