Re: using multiple partitions for a single table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Taher H(dot) Haveliwala" <taherh24(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: using multiple partitions for a single table
Date: 2001-09-06 02:57:46
Message-ID: 29225.999745066@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Richard NAGY 2001-09-06 12:14:16 Need help or advices : databases and tables invisibles and not accessibles !
Previous Message Chad R. Larson 2001-09-06 02:19:32 Re: using multiple partitions for a single table